Hello,
Please help me on how to assign a sequential number to each unique entry.
I have the list of identifiers for different companies, e.g.:
A
A
A
AAI
AAI
AAPL
AAPL
I would like to assign a unique number to each company, e.g.:
A 1
A 1
A 1
AAI 2
AAI 2
AAPL 3
AAPL 3
Thank you
Last edited by SunSpot; 04-17-2014 at 11:19 AM.
Put the first 1 in manually into B1, then in B2 and copied down:
=IF(A2=A1,B1,B1+1)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you!
You are welcome, but in future, please provide a link if you have posted the same question on another forum.Originally Posted by SunSpot
I'll definitely do that. Sorry for the repetition!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks