comparing 3 columns
=AND(A2:A9=B2:B9,B2:B9=C2:C9)
as an array formula (confirmed with Ctrl+Shift+Enter) gives true if all
cells in the three columns are equal.
Stefi
€˛Stefi€¯ ezt Ć*rta:
=AND(A2=B2,B2=C2)
returns True if A2=B2=C2
Fill it down as necessary!
Regards,
Stefi
€˛Ukiuki€¯ ezt Ć*rta:
How do I compare 3 columns? Need to know the data in all 3 columns are the
same.
|