View Single Post
  #1   Report Post  
Old July 24th 11, 02:21 AM
old coach old coach is offline
Junior Member
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 14
Default Count Consecutive A's with a reset

name wk1 wk2 wk3 wk4 wk5 wk6 counting backwards, wks missed
a x x x x x A 1
b x x A A x x 0
c x x x x x A 1
d x x x x x x 0
e x x x A A A 3
f x x x x x x 0
g A A A A x x 0
h x x x x A x 0
i x x x x x x 0
j x x A A A x 0
k x x x x x x 0
l x x x A x x 0
m x x x x A A 2

Sorry the spreadsheet didn't copy well!
The answer is in the last column.
This will be a 52 week chart, renewable each year.
Question I'm trying to answer: How many weeks beginning with this week, has the person missed consecutively? Once an X is reached the count stops.
Counting from wk6 toward wk 1.