Before I get started, here is a link to the sheet example
Essentially what I want to do is Count the number of times the value in C5 occurs consecutively in its first occurrence.
- In the example on Sheet1, the value would be 5 because Hawaii occurs 5 in a row before changing values.
- In the example on Sheet2, the value would be 2 because of Air Force occurs 2 in a row before changing values
I count use the Countif() but I only want the consecutive count for the first instance.
Any tips would be appreciated.