If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
comparing 3 columns
How do I compare 3 columns? Need to know the data in all 3 columns are the
same. |
#2
|
|||
|
|||
comparing 3 columns
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 "Ukiuki" wrote in message ... How do I compare 3 columns? Need to know the data in all 3 columns are the same. |
#3
|
|||
|
|||
comparing 3 columns
=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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
comparing 3 columns
I forgot to mention to adjust ranges!
Stefi „Stefi” ezt *rta: =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. |
#6
|
|||
|
|||
comparing 3 columns
Thanks!
"Stefi" wrote: =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. |
#7
|
|||
|
|||
comparing 3 columns
You are welcome! Thanks for the feedback!
Stefi „Ukiuki” ezt *rta: Thanks! "Stefi" wrote: =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. |
Thread Tools | |
Display Modes | |
|
|