Hi All,
I'm basically trying to add a number in the column next to a list, but so that each value in the list has it's own numbering. Example:
A 1
B 1
C 1
B 2
B 3
C 2
A 2
B 4
C 3
A 3
Basically the numbers on the right are numbering the occurrences of A, B and C independently.
I tried using the MATCH function to do this, but I've only been able to get sequential numbers in column B...
This is what I've used:
Please Login or Register to view this content.
Thanks for your help!
Hi,
Not sure about adapting this to your table structured references, but based on a list starting in A1:
=COUNTIF(A$1:A1,A1)
and copy down.
Cheers
Maybe:
Please Login or Register to view this content.
Wow...thanks XOR LX! That was easy
EDIT: Sorry John, you got beat to the punch!
You're welcome!
You managed to get the equivalent formulas in structured references, then? I wouldn't mind knowing what they are, just out of interest. Never use Tables myself, mainly because I find the structured referencing in formulas to be more hassle than it's worth. Still, we all have to learn...
Cheers
Oh well, that's the breaks!!Originally Posted by habsfan1433
"Beat to the punch"? "That's the breaks"?
I think my "North American" English needs some work!!
See. There's a lot more you can learn on this Forum than just Excel."Beat to the punch"? "That's the breaks"?
I think my "North American" English needs some work!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks