| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
One way
=IF(ISNUMBER(MATCH(B1,$A$1:$A$20,0)),B1,"") copy down, if there are duplicate entries use dataadvanced filter to create a distinct list -- Regards, Peo Sjoblom (No private emails please) "ruby2sdy" wrote in message oups.com... Hi Can anyone please help me compare two columns of text to come up with a list of items that are in both lists Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create multiple columns from a one-column list in Excel? | Excel Worksheet Functions | |||
| Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions | |||
| Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel | |||
| drop down list multiple columns | Excel Discussion (Misc queries) | |||
| Compare Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
