Looking up columns

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: babiq <babiq.1u0d6c_1124449505.6522@xxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 19 Aug 2005 05:43:17 -0500

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

--
babiq
------------------------------------------------------------------------
babiq's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25480
View this thread: http://www.excelforum.com/showthread.php?threadid=397158

.

Follow-Ups:
- Re: Looking up columns
  - From: Dave Peterson
- Re: Looking up columns
  - From: Bob Phillips

Prev by Date: Re: Define a dynamic range from a specific starting point in a list
Next by Date: Re: The best elegant solution to override 65k rows limit in a sheet
Previous by thread: Save behavior while in Edit/Enter mode
Next by thread: Re: Looking up columns
Index(es):
- Date
- Thread

Relevant Pages

Re: Uni Tricks Clips Game!
... remember to not only match it but come up with your own 4 trick combo. ... then i will have a go at matching that. ... tomsey's Profile: http://www.unicyclist.com/profile/7038 ... Prev by Date: ...
(rec.sport.unicycling)
Re: How do I use ISNA on this formula
... Column P matching the value in A12 then type this: ... if a match for the value in A12 can not be found in P12:P3323 ... Cutter's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=9848 ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)
problem adding
... My spread sheet ... rvnwdr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23903 ... Prev by Date: ...
(microsoft.public.excel.misc)
RE: Formula counts incorrectly
... > I assume that it is only counting 5/5/2005 one time? ... > Could someone please modify this formula to work the way I want it to? ... > was's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20211 ... Prev by Date: ...
(microsoft.public.excel.misc)
Copying into ranges
... through List B, and any number thats in List A, I want to copy a new ... formula to the neighbouring cell. ... carlito_1985's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21390 ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)