Re: excel problem
If starting data is in A2 (to work, data has to start in row 2 or higher), do the following. No VBA required:
in B2, formula will be "=IF(A2=A3,B1+1,0)", copy down.
in C2, formula will be "=IF(B2=0,B1+1,"")", copy down.
You can hide column B for neatness.
|