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)