Say 1st column is column A, 2nd column is column B.
Enter in C1:
=IF(ISNA(VLOOKUP(A1,B:B,1,0)),"",VLOOKUP(A1,B:B,1, 0))
and drag down

HTH
--
AP

"fak119" a écrit dans le message de news:
...
I have to columns, alphabetically sorted, one with 1oo names, one with
8o-9o
names, which are identical to the ones in the column with 1oo.

Is there a way (formula or macro) that places the identical text (names)
next to each other in the same row, leaving blank the cell where there is
no
match?

The columns should then look like this:

Miller Miller
Smith
Kerry Kerry
Ferguson Ferguson
Peters
Black Black

etc.


Thank you