Compare 2 Columns - Find Differences

I have data in 2 columns ("B" and "D") and I want to report off of the outliers. Column B has a name, "Michael" and Column D has a number.
I want to be able to tell when a name has more than 1 color in the corresponding column. for eaxample:

Michael 11002
Michael 11002
Michael 11173
Carl 55689
Carl 55689
Dana 33749
Dana 33529

michael and Dana have disrepencies, so I want to highlight them. What is the best way to do this? I am well versed in Access VBA, but Excel, I am a bit lost. I do not want to have to do this via a pivot chart, perhaps an array? I am open to suggestions.

Hi michaeljryan,

you can use below formula in column E1 & drag it down

=COUNTIF($B$1:$D$7,D1)

you will get the count how many times name has appeared

Thanks
A

Thank you for the suggestions, however this is not exactly what I need. Let me explain further:
The names are listed with a correspoding number. Columns B and D, respectively. The names can be listed an inconsistant number of times, but I wat to check the first name\Number combo against other name\number combos where the name is the same as the previous row:

Michael 11002 --this is okay
Michael 11002--this is okay
Michael 11173 Discrepency- name matches from previous row, but the number does not match first occurance of number for that name (11022)
Carl 55689--this is okay
Carl 55689--this is okay
Dana 33749--this is okay
Dana 33529--Discrepency- name matchesfrom previous row, but the number does not match first occurance of number for that name (11022)

I found a solution!

I first check for uniqueness of the name (1,0) then I check to see if the numer matches the previous.

=IF(AND(IF(B2<>B1,1,0)=0,D2<>D1), "Outlier", "Match")

Assuming the data starts on row 2:

=IF(B2=A1,IF(D2<>B1,"Discrepancy",""),"")