Need a Formula to identify incorrect data entries

[Steve N.]

Hello,

I'm trying to validate entries on a large s/s where if the values in col a are equal, the corresponding entries in col b should be equal. If the corresponding entries in col b are not equal, then all entries in those a&b cells need validated. Sample attached.

[Moo the Dog]

Here's a way, using a helper column:

In cell D2, type: =A2&B2
Then use this formula in cell C2: =IF(COUNTIF(A:A,A2)=COUNTIF(D:D,D2),"Ok","Validate")

- Moo

[Steve N.]

Perfect! Thanks Moo...

[Moo the Dog]

Glad to help, and thanks for the feedback. It's always appreciated.

- Moo