| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count and Reset Button Clicks | Excel Discussion (Misc queries) | |||
| Count max consecutive cells | Excel Discussion (Misc queries) | |||
| count cells, then reset count when value in another cell changes | Excel Worksheet Functions | |||
| Reset sheet count | Excel Discussion (Misc queries) | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Linear Mode
