Question description:
This user has given permission to use the problem statement for this
blog.
I need to make it so when no data has been entered to a specific column in 6 months the data will reset back to 0
Solved by X. W. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
10/04/2018 - 05:30
Hi…Welcome to Got It Pro
User
10/04/2018 - 05:30
hello
Excelchat Expert
10/04/2018 - 05:31
Do you have any specific data or file to share to illustrate this ?
User
10/04/2018 - 05:31
no I can try to explain what I am doing
Excelchat Expert
10/04/2018 - 05:32
sure...please do
User
10/04/2018 - 05:32
I am tracking employee points for being late to work or missing work
User
10/04/2018 - 05:32
when an employee misses work it is 1 point
User
10/04/2018 - 05:32
late is .5 points
User
10/04/2018 - 05:33
these points add up unless they have not gotten any points in the past 6 months
Excelchat Expert
10/04/2018 - 05:33
ok...so are you tracking this monthly say a column for each month?
User
10/04/2018 - 05:33
So I need to figure out a way to get the points on my excel spreadsheet to delete after no points have been added in the past 6 months
Excelchat Expert
10/04/2018 - 05:33
Yes, we can do that.
User
10/04/2018 - 05:33
its tracked by event
User
10/04/2018 - 05:34
so each time a employee misses i enter the name of the employee, date, and point
Excelchat Expert
10/04/2018 - 05:34
ok let's do an example in this blank sheet
User
10/04/2018 - 05:34
ok
Excelchat Expert
10/04/2018 - 05:36
Do you have it tracked something like this?
User
10/04/2018 - 05:37
yes
Excelchat Expert
10/04/2018 - 05:37
ok then I suggest a way to get the months consolidated into a monthly sheet
Excelchat Expert
10/04/2018 - 05:37
Let me add another sheet for monthly
User
10/04/2018 - 05:38
ok
Excelchat Expert
10/04/2018 - 05:56
I am still working on this
User
10/04/2018 - 05:56
i see
Excelchat Expert
10/04/2018 - 06:08
ok...please see the formula in N2
Excelchat Expert
10/04/2018 - 06:08
this will work even if you extend to have more than 12 months.
Excelchat Expert
10/04/2018 - 06:08
just be changing the cell reference
Excelchat Expert
10/04/2018 - 06:09
I think we will be running out of time.
Excelchat Expert
10/04/2018 - 06:09
please download the file or copy this formula for future reference.
User
10/04/2018 - 06:09
thanks
Excelchat Expert
10/04/2018 - 06:10
Great...please do rate me
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.