Two people checked the same equipment. The rows that need a conversation are the ones where one marked OK and the other marked Review.

Convert both statuses into pass flags

With the two statuses in B2 and C2, enter the following in D2:

=XOR(B2="OK",C2="OK")

For two Boolean conditions, XOR returns TRUE when exactly one is true. Keep the status wording consistent, including stray spaces, before comparing rows.

The mixed pairs OK and Review return TRUE in either order.

Illustrated truth table. TRUE means the two pass flags differ.

Distinguish agreement from an incomplete check

Test OK/Review, Review/OK, OK/OK and Review/Review. The first two give TRUE and the last two FALSE. Two Review entries agree even though the item still needs attention.

Both OK and both Review return FALSE, while unfinished checks need their own status.

Illustrated interpretation. Agreement can be two passes or two reviews.

In this formula, a blank does not match OK. If a blank means the review is pending, keep it in a separate pending group and use the XOR flag for completed pairs.

Microsoft’s Excel function reference