Home |
Search |
Today's Posts |
#1
|
|||
|
|||
common entries between 2 columns
I have two lists of numbers or names and I want to find the ones that are
common between the 2. The lists are say column A and column B in excel. |
#2
|
|||
|
|||
Andreas,
In cell C1, use the formula =IF(ISERROR(MATCH(B1,A:A,FALSE)),"","Also in column A") And copy down to match your list in column B. You can write a similar formula to highlight the values in column A. HTH, Bernie MS Excel MVP "Andreas" wrote in message ... I have two lists of numbers or names and I want to find the ones that are common between the 2. The lists are say column A and column B in excel. |
#3
|
|||
|
|||
Hi,
Try this. Assuming you have one list in range A1:A5 and the other one in range B1:B5, enter hter following array formula (Strl+Shift+Enter) in cell C1 =OR(EXACT(A1,$B$1:B5)) Regards, "Andreas" wrote: I have two lists of numbers or names and I want to find the ones that are common between the 2. The lists are say column A and column B in excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns | Excel Discussion (Misc queries) | |||
Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
Remove dup entries in 2 columns 70,000+ | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |