Hello, I am in need of some assistance with this type of VBA coding.
Example -
Col B Col C
X X
X X
X X
X X
X X
E X
X X
X X
X E
X X
I want a counter to show how many X's in a row there is outputted in a different Cell - BUT i want that counter to "reset" when it see's E - then resets Count.
So from Col B it had 5 in a row - but count gets Resets to 4. and the Count doesnt have to be Automatic (if so be nice) otherwise have a VBA Command key to RUN macro to do it. Any thing will be helpful!
thanks.