CODEWITHSUNDEEP
excel
JungleDiff
JungleDiff

Reputation: 3505

Excel: how to return True if every value in the two column match?

How do I return TRUE if and only if every cell in two columns matches with one another?

For example, let's say I have this data: enter image description here

This should return FALSE because the the data in row 7 do not match.

However, enter image description here

this should return TRUE because every row in the two columns have the same values.

I would really appreciate your help!!!

Upvotes: 0

Views: 196

Answers (1)

teylyn
teylyn

Reputation: 35935

Try this

=SUMPRODUCT(--($A$2:$A$7=$B$2:$B$7))=COUNTA($A$2:$A$7)

Upvotes: 1

Related Questions