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.

[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]Column A [/TD]
[TD] Column B[/TD]
[/TR]
[TR]
[TD]phillips@aol.com[/TD]
[TD]dkz134d[/TD]
[/TR]
[TR]
[TD]Roger@timewarner.com[/TD]
[TD]zks441d[/TD]
[/TR]
[TR]
[TD]phillips@aol.com[/TD]
[TD]fgp231y[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.