ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Count Consecutive A's with a reset (https://www.excelbanter.com/excel-worksheet-functions/270426-count-consecutive-reset.html)

old coach

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.


All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com