Compare and Match

I have a report which shows the ID#s and the names corresponding to those IDs.

I am trying to write a formula which check the ID# and see if the same ID#s have the same Name;

if the same ID #s  are listed more then once and they have different names then it should show that the IDs and names do not match.

The idea is that same ID#s should have the same name; if the same ids have different names then it should show that ID have different names.
I have added an image of the worksheet

Col A     Col B       Col C

ID        Name         Desired Output
3         Peter        ID with multiple names
3         Ken          ID with multiple names
5         Chris        match
5         Chris        match
5         Chris        match
6         Dave         match
6         Dave         match
7         Lisa         match
8         Mark         match
10        Ken          match
12        Frank        ID with Multiple names
12        Randy        ID with Multiple names 
12        Frank        ID with Multiple names
12        Mike         ID with Multiple names 

 

 

By: Nomi

Leave a Reply

Your email address will not be published. Required fields are marked *