Looking up columns

[babiq]

hi there

I've got 2 columns with various names in them, roughly 2000 of them!

Each column might have the same name in them.

What i want to do is to produce a new column/list, which consists of
all the matching names from both columns.

PLease can you help.

Many thanks

 

[Bob Phillips]

Put this in C1 and copy down

=IF(COUNTIF($B$1:$B$2000,A1)>0,B1,"")

 

[Dave Peterson]

Say your names are in columns A and B.

Put this in C1 and drag down:

=isnumber(match(a1,b:b,0))

This will return TRUE if the name in A1 matches any name in column B.

Now you can apply data|filter|autofilter to show just the trues. Copy those
visible cells in column A to a new location (new worksheet???).