| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Hi,
Try this array formula (Ctrl+Shift+Enter) =if(OR(EXACT(A3,Names1!$A$3:A5)),A3,"") where A3 is from the first column and Names1!$A$3:A5 is from the second column Regards, Ashish Mathur "ruby2sdy" wrote: 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
