Posted to microsoft.public.excel.misc

Ian

external usenet poster

Posts: 109

duplicates

i found the option to delete duplicates, but i want to delete everything but
duplicates?

i have
column 1 with 2500 names,
column 2 with all the 2500 usernames corresponding to column ones names , and
column 3 with the list of names we need about 600

and i want to filter out of column 1 and 2 all the names that do not match
the column 3 list,
please advice
thanks
ian

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
Condensing a list with duplicates to a list with non-duplicates	Nuclear	Excel Worksheet Functions	2	July 29th 08 08:03 PM
Duplicates in excel that aren't 100% DUPLICATES ...	[email protected]	Excel Discussion (Misc queries)	4	May 2nd 08 06:43 PM
Duplicates	Guy Lydig	Excel Discussion (Misc queries)	7	November 20th 07 04:40 AM
Help with Duplicates	rlee1999	Excel Worksheet Functions	3	September 19th 06 09:16 AM
Please Help With Duplicates	Dee	Excel Discussion (Misc queries)	2	January 21st 06 03:57 PM

All times are GMT +1. The time now is 02:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us