Create a unique ID for rows with same name and date of birth

[VickyW]

Hi All

This is a cross-post from another forum that I'd not had much luck from
Fingers crossed someone here will be able to help

I am trying (and failing) to add a unique ID field to my employee data set

Is there any way to calculate a unique ID for those records with the same name and date of birth?

Ideally the ID would have at least 6 numbers after the prefix 'ID' i.e ID000102 or ID003217 as some the data sets are 15,000+ rows

All advice welcome
All the best,
Vicky

 

[denzo36]

I'd first recommend removing duplicates based on name and DOB, that way you'd have a unique list of people. Then you can insert 'ID000001' into cell A1 of your ID field and fill down which will increment it by one for each row

 

[VickyW]

Hi Denzo36

Thanks. That does seem like a much more sensible approach!

Each row contains a different type of appointment for the employee, so I still need the info, but I can create a unique list of names+dob's, assign each one an ID, then link the remaining the data back with =INDEX(MATCH

Thank you!

 

[denzo36]

No problem!