|
| 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
September 12th, 2008, 11:17 AM
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
September 12th, 2008, 11:42 AM
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
September 12th, 2008, 11:45 AM
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
September 12th, 2008, 11:51 AM
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
September 12th, 2008, 11:56 AM
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
September 19th, 2008, 05:16 PM
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
September 22nd, 2008, 08:01 AM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
