Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two columns
I have a number of ids in two columns and am trying to represent which ones
in the second column also appear in the first. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two columns
One way...
Comparing column B to column A with the list in column A in the range A1:A20. =IF(COUNTIF(A$1:A$20,B1),"match","") Copy down as needed. -- Biff Microsoft Excel MVP "JoeM" wrote in message ... I have a number of ids in two columns and am trying to represent which ones in the second column also appear in the first. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two columns
Apply the formula in C1 which will check the value of B1 in A and return Y or N
=IF(COUNTIF(A:A,B1)0,"Y","N") -- If this post helps click Yes --------------- Jacob Skaria "JoeM" wrote: I have a number of ids in two columns and am trying to represent which ones in the second column also appear in the first. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two columns
JoeM wrote:
I have a number of ids in two columns and am trying to represent which ones in the second column also appear in the first. Assuming your two columns are A and B, select column B and enter this for conditional formatting: =COUNTIF($A:$A,B1)0 Select the format you want to "represent" matches. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two columns
"T. Valko" wrote...
One way... And the slow way . . . Comparing column B to column A with the list in column A in the range A1:A20. =IF(COUNTIF(A$1:A$20,B1),"match","") Bit faster to use =IF(COUNT(MATCH(B1,A$1:A$20,0)),"match","") or just =MATCH(B1,A$1:A$20,0) which would return a number when there's a match and #N/A when there isn't. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two columns
I'm bored too!
-- Biff Microsoft Excel MVP "Harlan Grove" wrote in message ... "T. Valko" wrote... One way... And the slow way . . . Comparing column B to column A with the list in column A in the range A1:A20. =IF(COUNTIF(A$1:A$20,B1),"match","") Bit faster to use =IF(COUNT(MATCH(B1,A$1:A$20,0)),"match","") or just =MATCH(B1,A$1:A$20,0) which would return a number when there's a match and #N/A when there isn't. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing 3 columns | Excel Worksheet Functions | |||
comparing columns | Excel Discussion (Misc queries) | |||
Comparing Columns to each other | Excel Discussion (Misc queries) | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
comparing columns | Excel Worksheet Functions |