Ok I may need to go into some detail.
I have table that has 4 columns
A = Dates
B = Names
C = Names2
D = Scores
I want to be able to identify when
Name X had a score for today and yesterday ( Today-1)
also 3 scores in 4 days
and 4 scores in 5 days.
I am trying to determine the effect of being over worked if you will.
In summary I want to know effects of
back to back days.
3 scores in 4 days
4 scores in 5 days
So I am trying to come up with a moving array that I can drag down and it automatically compute.
Make sense?