#1   Report Post  
Posted to microsoft.public.excel.misc
Ian Ian is offline
external usenet poster
 
Posts: 109
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default duplicates

If you have in A1:An Names, B1:Bn UserNames, and in C1:Cn the names
you want to match the Names with the user name in D1:Dn, say, you may
applay the following formula in D1:D2500, NOT TO D600,

=IF(ISNUMBER(MATCH(C2,$A$2:$A$2500,0)),INDEX($A$2: $A$2500,MATCH(C2,$A
$2:$A$2500,0)),"")

This formula applied to D1:D2500, will give you the user names of the
names already in C1:C600
But if something is not found it will leave the cell blank, therefore
after applying this formula, you will need to get rid of the blanks.
(this is another thing)
Try it for now, if it does your job and later we will see about the
blank cells.
I am sure a VBA code, or a more expert person would do it better.
If this helps, Leave me a feedback please.
Regards, Totti.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"