Sorry if this is somewhere on the forum already, I wasn't exactly sure what to search to find this answer.
I'm not sure how to phrase this, so let me show you what I'm trying to achieve first:
Column A Column B A 1 A 2 A 3 B 1 B 2 C 1 A 4 D 1 B 3 A 5
So basically, I need to incrementally number the various values in column A... into column B, but identical values won't always be be next to each other. It won't go A, A, A, B, C, D, D... it will be mixed up like the table above. Another important point is there's not a finite number of values for column A, I'm only using the alphabet to simplify my question.
To start, I've figured out a way to count the number of count the total number of each value in Column A using =COUNTIF($A$2:$A,A2:A), leading to this result:
Column A Column B A 5 A 5 A 5 B 3 B 3 C 1 A 5 D 1 B 3 A 5
I thought that might lead me somewhere, but now I'm stuck as to where to go from here. I did find this page showing how to do something similar:
http://stackoverflow.com/questions/1...olumn-resettin
=if(A2=A1,B1+1,1) seemed close... but that was for values that are in order.
Anyone have any ideas on how I could achieve this? Is it possible with a formula, or do I need a Macro?
Thanks for any help!
Bookmarks