How to identify inconsistent data?

[TomC4]

Imagine I have a spreadsheet with three columns: Property ID, Property Owner, Contract Type. Multiple properties can have the same owner. Each property belonging to a single owner should have the same Contract Type. I have a big spreadsheet with data like this. Is there a way I can identify Property Owners that do not have the same Contract Type associated with each of their properties?

Here is an example to help clarify. Property Owner B's data looks good because each of her two properties have the same Contract Type. But Property Owner A's data should be flagged for review because she has properties with different Contract Types.

 

[6StringJazzer]

What version of Excel are you using? (Would be good to update your profile) The answer for Excel 365 might be different than older versions.

 

[6StringJazzer]

Here is one way. Add a column and use this starting in row 2

=IF(COUNTIFS(B:B,B2,C:C,C2)<>COUNTIF(B:B,B2),"Review","")

The row will show REVIEW if the owner in that row has more than one type of contract. This assumes the columns you showed us are A, B, C.

 

[TomC4]

Here is one way. Add a column and use this starting in row 2

=IF(COUNTIFS(B:B,B2,C:C,C2)<>COUNTIF(B:B,B2),"Review","")

The row will show REVIEW if the owner in that row has more than one type of contract. This assumes the columns you showed us are A, B, C.

This code worked fabulously. Sorry for the late reply. Thank you!