| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing 3 columns
How do I compare 3 columns? Need to know the data in all 3 columns are the
same. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing columns | New Users to Excel | |||
| Comparing Two Columns | Excel Discussion (Misc queries) | |||
| Comparing two columns | Excel Worksheet Functions | |||
| Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
| comparing columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
