comparing 3 columns

[Ukiuki]

How do I compare 3 columns? Need to know the data in all 3 columns are the
same.

 

[Ashish Mathur]

Hi,

Let's say that your data is set up like this in range A1:C4.

1 4 6
2 5 1
3 6 7
4 1 8

Now while in cell A1, go to Format > Conditional formatting type the foll.
formula in "Formula is" =COUNTIF($B$1:$C$4,$A1)>=1. Select the font color
desired.


--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Stefi]

=AND(A2=B2,B2=C2)
returns True if A2=B2=C2
Fill it down as necessary!

Regards,
Stefi

„Ukiuki†ezt írta:

 

[Stefi]

=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:

 

[Stefi]

I forgot to mention to adjust ranges!
Stefi


„Stefi†ezt írta:

 

[Ukiuki]

Thanks!

=AND(A2=B2,B2=C2)
returns True if A2=B2=C2
Fill it down as necessary!

Regards,
Stefi

„Ukiuki†ezt írta:

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Ukiuki†ezt írta: