What formula do I use to count consecutive cells based on criteria, however I need the counter to restart if a different value from the previous one is found?
Any help given is appreciated
What formula do I use to count consecutive cells based on criteria, however I need the counter to restart if a different value from the previous one is found?
Any help given is appreciated
B1: 1
B2: =IF(A2=A1,B1+1,1)
copy B2 down
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber