Hi,
I have column A1 that contains names eg ..
Jones
Jones
Jones
Williams
Williams
Davies
Davies
Davies
Davies
I would like column A2 to automatically generate in numerical order an ID number - All Jones = 1 Williams = 2 and so on.
Jones 1
Jones 1
Jones 1
Williams 2
Williams 2
Davies 3
Davies 3
Davies 3
Davies 3
The names in column A1 will change from sheet to sheet - but will always start with ID 1.
Cheers for all your help
WCE
Put this formula in B2 if your data starts in A2Formula:
Please Login or Register to view this content.
Put this formula in B3 and drag downFormula:Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
With your Names starting in A1 and down, in B1 type 1. In B2 anf copy down, use this formula.
=IF(A2="","",IF(COUNTIF($A$1:A2,A2)>1,INDEX($B$1:B1,MATCH(A2,$A$1:A2,0)),MAX($B$1:B1)+1))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Fantastic - Cheers
.....................
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks