I've been trying to work on a project for my employer.
We are a member organisation where each membered account is given an internal ID, however, the same person can have multiple accounts.
We're trying to instigate a Unique ID which is individual to each separate person, use a reversed Date of Birth : YYYYMMDDXX
The XX suffix is dependent if the same date of birth recurs within the data set, but with a different user's name.
I've tried using Countif to try and work this out, but it seems to have an issue if a member has more than 3 different accounts.
Would anyone be able to help? I don't mind if the odd ID requires manual checking, but at the moment, I've got several hundred to review.
I've included a sample of my data.