loudnoiseman
Board Regular
- Joined
- Dec 31, 2004
- Messages
- 218
- Office Version
- 365
- Platform
- Windows
Hi All,
I'd like to count how many times a numerical value repeats in a range as a consecutive duplicate - I didn't see any related posts...
For example, the value is in A2 and the range is D2:Z2 and I'd like to place the formula in B2 to return the # of consecutive duplicates.
With comma's separating cells, let's say value is 3 and range is: 4,6,8,3,3,5,3,3,8,9,2 etc.
In this short excerpt the result would be 2.
Thanks!!
I'd like to count how many times a numerical value repeats in a range as a consecutive duplicate - I didn't see any related posts...
For example, the value is in A2 and the range is D2:Z2 and I'd like to place the formula in B2 to return the # of consecutive duplicates.
With comma's separating cells, let's say value is 3 and range is: 4,6,8,3,3,5,3,3,8,9,2 etc.
In this short excerpt the result would be 2.
Thanks!!