errollflynn
New Member
- Joined
- Jan 25, 2021
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
Hello,
I have the data set below and am looking for a formula that will identify instances where there are six or more non blank, adjacent cells in a row. I've tried various forms of using counta with no success.
Thank you in advance.
I have the data set below and am looking for a formula that will identify instances where there are six or more non blank, adjacent cells in a row. I've tried various forms of using counta with no success.
Thank you in advance.
| Book3 | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | |||
| 1 | Sum of Shift | Months | |||||||||||||
| 2 | Row Labels | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | ||
| 3 | Person A | 8 | 25 | 28 | 25 | 26 | 28 | 23 | 30 | 28 | |||||
| 4 | Person B | 23 | 20 | 21 | 22 | 18 | 21 | 21 | 22 | ||||||
| 5 | Person C | 12 | 22 | 27 | 25 | 24 | 21 | 12 | 18 | 30 | 23 | 19 | |||
| 6 | Person D | 7 | 14 | 25 | 28 | 22 | 14 | 16 | 23 | 26 | 15 | ||||
| 7 | Person E | 3 | 18 | 26 | 25 | 10 | 11 | 26 | 18 | 18 | |||||
Sheet1 | |||||||||||||||
