I am trying to find a way of gathering data for the last 90 days that will update itself.
I am running one sheet (DUTIES) which lists data from January 1st 2013 to the present day. Column A lists dates, columns B to M represent 12 individuals. Three types of data are listed under each individual; LV, MM or JJ (or blank) on each day they work.
I want to display how many MM and JJ events each individual has conducted over the last 90 days, in a cell on a separate sheet (SUMMARY).
It would also be nice if I could enter a given day in a cell and have the outputs on the SUMMARY sheet show how many MM and JJ duties were conducted in the preceding 90 day period.
I'm an Excel newbie so please type slowly!
Thanks
I am running one sheet (DUTIES) which lists data from January 1st 2013 to the present day. Column A lists dates, columns B to M represent 12 individuals. Three types of data are listed under each individual; LV, MM or JJ (or blank) on each day they work.
I want to display how many MM and JJ events each individual has conducted over the last 90 days, in a cell on a separate sheet (SUMMARY).
It would also be nice if I could enter a given day in a cell and have the outputs on the SUMMARY sheet show how many MM and JJ duties were conducted in the preceding 90 day period.
I'm an Excel newbie so please type slowly!
Thanks