View Single Post
  #1   Report Post  
Old July 26th 11, 03:46 AM posted to microsoft.public.excel.worksheet.functions
Dwayne Gunnels Dwayne Gunnels is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2011
Posts: 1
Default counting absentees

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.