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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
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