formula for finding differences after grouping

[flyers2thecup]

sorry for poor title!

If i have Names in column A, then a Rating (1, 2 or 3) in column B....Lets say JOHN DOE is listed in column A, 8 times. I want to find out if all his ratings are the same in column B. Column C just needs to indicate that not all JOHN DOE's ratings match. Hopefully that makes sense.

JOHN DOE 3
JOHN DOE 3
JOHN DOE 1
JOHN DOE 3
JOHN DOE 3
JOHN DOE 2
JOHN DOE 3
JOHN DOE 3

 

[NMa91]

Please insert formula like this in range c1 and drag to cells below:

=IF(COUNTIF(A:A,A1)=COUNTIFS(A:A,A1,B:B,B1),"Match","No Match")

 

[flyers2thecup]

Thank you for the quick reply...unfortunately...ALL fields are returning MATCH...even though there are some SINGLE names in column A.

 

[NMa91]

For single name data, do you want to show "no match"?

 

[flyers2thecup]

That will work. Sorry for not explaining that too well the first time.

 

[NMa91]

Apply this formula:

=IF(OR(COUNTIF(A:A,A1)=1,COUNTIF(A:A,A1)<>COUNTIFS(A:A,A1,B:B,B1)),"No Match","Match")

 

[flyers2thecup]

thanks for the response. results arent 100% what im looking for. still getting MATCH or NO MATCH on csrtain fields that shouldnt.

can i upload a portiin of my spreadsheet?

 

[NMa91]

Yes, Please upload more data.

 

[flyers2thecup]

sorry...working from phone as my employer has blocked site.

cant find how to attach spreadsheet.

 

[flyers2thecup]

https://www.dropbox.com/s/c74jbv7euun71jx/compare.csv?dl=0