anonymouspottamus
New Member
- Joined
- Oct 7, 2023
- Messages
- 4
- Office Version
- 2016
- Platform
- MacOS
What excel formula would I use to count how many consecutive numbers there are in each row of my data source? The data source is A2:E183.
Example:
Row A2 has numbers 13 14 21 28 31
Row A3 has numbers 18 23 29 30 31
How do I find the number of consecutive numbers in row A2?
How do I find the number of consecutive numbers in row A3?
Example:
Row A2 has numbers 13 14 21 28 31
Row A3 has numbers 18 23 29 30 31
How do I find the number of consecutive numbers in row A2?
How do I find the number of consecutive numbers in row A3?