| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to find common cells in several columns
Hi, can anyone help me on this? Let say we have 3 columns of data. I want to
show in another column for data that appears in all 3 columns. E.g. A B C 1 apple orange education 2 education education card 3 flower apple flower 4 baby phone baby 5 phone baby apple I want to return "apple", "education" and "baby" in another column since these 3 terms appear in all 3 columns. Is there a way that I can do it quickly? Thanks in advance for your help!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find and highlight common text in multiple columns | Excel Discussion (Misc queries) | |||
| comparing two columns of data to find common values | Excel Discussion (Misc queries) | |||
| How do I find items common to two columns in Excel? | Excel Discussion (Misc queries) | |||
| How do I find items common to two columns in Excel? | Excel Discussion (Misc queries) | |||
| How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
Threaded Mode
