Looking up columns

  • Thread starter Thread starter babiq
  • Start date Start date
B

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
 
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???).
 
Back
Top