|
comparing 3 columns
How do I compare 3 columns? Need to know the data in all 3 columns are the
same. |
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. |
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. |
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. |
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. |
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. |
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. |
| All times are GMT +1. The time now is 05:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com