Forum Discussion
Excel data questions
I would like to keep track of my fitness and activity in a excel document and would need some help.
I have 5 tabs:
A name list
Activity A, B, C, D (With headers of the name list and the date)
on a specific date, when I participate in the activity I’ll put a 1 and if I miss I’ll put a 0 (Or either a check or no check box)
How can I compile it back to the master name list such that if I miss 1 week consecutive of any exercise (A-D) it’ll flag out to be orange, 2 weeks of consecutive exercises will be flag red. If Let’s say they skip 6 days but do an exercise on day 7 it wouldn’t be flagged out and if they do exercise on day 13 that it wouldn’t be flagged as red
I’m doing up a 2 year programme, hopefully in one excel document but if it’s a 6 months excel sheet it would be good as well. Need help Urgently thanks !
I have 5 tabs:
A name list
Activity A, B, C, D (With headers of the name list and the date)
on a specific date, when I participate in the activity I’ll put a 1 and if I miss I’ll put a 0 (Or either a check or no check box)
How can I compile it back to the master name list such that if I miss 1 week consecutive of any exercise (A-D) it’ll flag out to be orange, 2 weeks of consecutive exercises will be flag red. If Let’s say they skip 6 days but do an exercise on day 7 it wouldn’t be flagged out and if they do exercise on day 13 that it wouldn’t be flagged as red
I’m doing up a 2 year programme, hopefully in one excel document but if it’s a 6 months excel sheet it would be good as well. Need help Urgently thanks !
