Posted to microsoft.public.excel.worksheet.functions

MAG

external usenet poster

Posts: 3

How do you compare names in two lists? One is a subset.

I want to Identify names from a larger list that are in the smallerlist. What
is the best way to do this? I tried using =ISNA(Match(F3,$E$3:$E$500,TRUE)),
where column F contains all of the names in array $E$3:$E$500 and about 3000
more. I had hoped to identify those in the array with a True or False and
then use a sort to select out the True entries.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I compare lists in cells Excel	Gerald Vandiver	Excel Worksheet Functions	0	June 14th 06 12:03 AM
Compare lists	teejay	Excel Worksheet Functions	0	January 24th 06 03:30 PM
Compare two lists?	s_tyrone	Excel Discussion (Misc queries)	1	November 30th 05 02:47 PM
How do I compare lists and eliminate duplictates	kateshere	Excel Discussion (Misc queries)	2	July 11th 05 08:39 PM
How do I compare two lists of names in excel?	Jack the Cate	Excel Discussion (Misc queries)	1	December 24th 04 12:07 PM

All times are GMT +1. The time now is 01:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us