BlackjuiceBabes
New Member
- Joined
- Jun 10, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
Hi
I am trying to count the number of consecutive number occurrences in a row. eg in the example below, there is one set ( 11 to 12)
In the second example below there are two sets, 12,13 and 22,23. I want to apply the formula for a wide range of rows.
I am trying to count the number of consecutive number occurrences in a row. eg in the example below, there is one set ( 11 to 12)
4 | 11 | 12 | 21 | 23 |
In the second example below there are two sets, 12,13 and 22,23. I want to apply the formula for a wide range of rows.
6 | 12 | 13 | 22 | 23 |