Easy Excel Question

[phillipsdp]

Hey guys,

I have a list of email addresses in column A and i have a unique identifier in column B that corresponds to the email address in column A, in a perfect world there would be one email address that corresponds to one unique identifier. I need to know when i have an email address that has more than one unique identifier, and when i have a unique identifier that has more than one email address.

Column A	Column B
phillips@aol.com	dkz134d
Roger@timewarner.com	zks441d
phillips@aol.com	fgp231y

<tbody>
</tbody>

 

[Kentetsu]

Just off the top of my head, I'd say use Data Validation to highlight any cells with duplicates. Would that suit your needs?

 

[phillipsdp]

It wouldn't provide me what im looking for I don't think, because it is ok to have duplicate email addresses as long as the duplicate email address consistently corresponds to the same unique identifier.