Assume the ranges are A1:A10, C1:C10, E1:E10, G1:G10

Create this named formula:
Goto InsertNameDefine:
Name: NameCount
Refers to:

=(COUNTIF($C$1:$C$10,$A$1:$A$10))+(COUNTIF($E$1:$E $10,$A$1:$A$10))+(COUNTIF($G$1:$G$10,$A$1:$A$10))

Then, enter this formula as an array using the key combination of
CTRL,SHIFT,ENTER (not just ENTER) where you want the extracted names to
appear:

=INDEX(A$1:A$10,SMALL(IF(NameCount=3,ROW(A$1:A$10)-ROW(A$1)+1),ROWS($1:1)))

Copy down until you get #NUM! errors meaning all names have been extracted.

Biff

"T. Valko" wrote in message
...
Is each column the same length? How about telling us the ranges?

Will a name appear in any column only once?

Biff

"JG" wrote in message
ups.com...
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)