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
|
|||
|
|||
comparing and isolating duplicates in two columns
Thanks for your help in advance.
If i have values in column A, and values in column B, is there a quick and easy formula that will isolate the duplicates--the values that are identical--in the two columns? It's basically comparing 2 lists, names for example, and trying to cross reference them. Thanks again. I hope someone can help. |
#2
|
|||
|
|||
comparing and isolating duplicates in two columns
Enter this in C1
=IF(COUNTIF($A$1:$A$100,B1)0,"Present in Col A","Not found in Col A") and copy down as far as you have entries in Col B after changing 100 to the last row of data in Col A You can use, in D1 to look in Col B for values in Col A =IF(COUNTIF($B$1:$B$100,A1)0,"Present in Col B","Not found in Col B") "monkeytrader" wrote: Thanks for your help in advance. If i have values in column A, and values in column B, is there a quick and easy formula that will isolate the duplicates--the values that are identical--in the two columns? It's basically comparing 2 lists, names for example, and trying to cross reference them. Thanks again. I hope someone can help. |
#3
|
|||
|
|||
comparing and isolating duplicates in two columns
One way...
Let's asume we're comparing column B to column A. Column A will contain only unique names. Enter this formula in C1 and copy down: =IF(COUNTIF(A$1:A$20,B1),"Match on row "& LOOKUP(1E100,1/(A$1:A$20=B1),ROW(A$1:A$20)),"") -- Biff Microsoft Excel MVP "monkeytrader" wrote in message ... Thanks for your help in advance. If i have values in column A, and values in column B, is there a quick and easy formula that will isolate the duplicates--the values that are identical--in the two columns? It's basically comparing 2 lists, names for example, and trying to cross reference them. Thanks again. I hope someone can help. |
Thread Tools | |
Display Modes | |
|
|