| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Common names in multi ranges
I have 4 columns of names. I would like to search all 4 columns (4
individual ranges) and find the names that appear in all 4 and copy the names to individual cells. The 4 Columns of names are with other data in the columns and they are spread out on the sheet. I could not search the whole column but only a range in a column ( 4 ranges actually), don't know if this will make a difference. Thanks for any help and Merry Christmas (Happy Holidays..... pc) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to find common data between to colums and match | Excel Worksheet Functions | |||
| Find a group of names in a long list | Excel Discussion (Misc queries) | |||
| Conditional Format - 2 lists of names to find matching cells. | Excel Worksheet Functions | |||
| How do I find items common to two columns in Excel? | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
Threaded Mode
