LinkBack URL
About LinkBacks
I have a large database that I need to assign sequential values to each group of unique values in a particular field. e.g. below.
Thanks for your help.
A 1
A 2
A 3
A 4
A 5
B 1
B 2
B 3
B 4
B 5
B 6
B 7
C 1
C 2
C 3
How does one create a list of sequential numbers for each unique value in a field?
I have a large database that I need to assign sequential values to each group of unique values in a particular field. e.g. below.
Thanks for your help.
A 1
A 2
A 3
A 4
A 5
B 1
B 2
B 3
B 4
B 5
B 6
B 7
C 1
C 2
C 3
With your values starting in A2 enter this in B2 and fill down:
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
See attached example.
Regards,
berlan
All you need is:Originally Posted by newdoverman
=COUNTIF(A$2:A2,A2)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Worked wonderfully! Thanks.
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
If there are blanks in the range, this might be of help:
Formula:Please Login or Register to view this content.
This will not count any blanks but leave a blank where the count would be and then resume when values are present in column A
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks