| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching information in two columns
Hi all,
I have two columns of data, column A and Column B. I want to check for all matches in columns A & B..how would I do this? thanks in advance, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Matching information in two columns
I just asked the same question, and here are two answers that I received:
The following compares two columns and checks if both cells on the same row are an exact match. Put this formula into a new column, and copy it down. =IF(A1=B1,"same","Different") The following checks the data in a cell in column one, and looks if there is the same data in any cell in column two. =SUMPRODUCT(--(A1=$b$1:$C$30)) copy these formulas down the column. It worked for me, and hope it works for you! -- newyorkjoy thanks for the help! "Greenback" wrote: Hi all, I have two columns of data, column A and Column B. I want to check for all matches in columns A & B..how would I do this? thanks in advance, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Matching information in two columns
sorry. it should be:=SUMPRODUCT(--(A1=$b$1:$b$30))
-- newyorkjoy thanks for the help! "newyorkjoy" wrote: I just asked the same question, and here are two answers that I received: The following compares two columns and checks if both cells on the same row are an exact match. Put this formula into a new column, and copy it down. =IF(A1=B1,"same","Different") The following checks the data in a cell in column one, and looks if there is the same data in any cell in column two. =SUMPRODUCT(--(A1=$b$1:$C$30)) copy these formulas down the column. It worked for me, and hope it works for you! -- newyorkjoy thanks for the help! "Greenback" wrote: Hi all, I have two columns of data, column A and Column B. I want to check for all matches in columns A & B..how would I do this? thanks in advance, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching 2 columns | Excel Worksheet Functions | |||
| Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
| matching on columns | Excel Discussion (Misc queries) | |||
| Matching cell information | Excel Worksheet Functions | |||
| Matching cells that have unrelated information | Excel Discussion (Misc queries) | |||
Linear Mode
