LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rtek
 
Posts: n/a
Default subtracting (extracting non-duplicate items)HELP!!


Please help, is there any way to do this? i will try to explain..

I have 2 huge lists. One is " the Master list" which I have to extract
items that are not already listed on the second list . I don't want to
remove duplicate entries,I want to remove the duplicates completely. in
both lists, so that I only have items that are not in the second
list...I did some searchin but i would really appreciate if someone
helped me..

like this..

List 1:
# $ % & * ! @
List 2:
# & @

so I want to end up with:
$ % * !


--
rtek
------------------------------------------------------------------------
rtek's Profile: http://www.excelforum.com/member.php...o&userid=34483
View this thread: http://www.excelforum.com/showthread...hreadid=542432

 
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
Extracting the Duplicate Records Santhosh Excel Discussion (Misc queries) 1 April 25th 06 02:16 PM
Find duplicate records in Excel 2003 Wayne Excel Discussion (Misc queries) 1 March 29th 06 12:47 AM
Preventing duplicate data tillytee1 Excel Discussion (Misc queries) 2 March 20th 06 03:49 PM
Keeping duplicate rows Daniell Excel Worksheet Functions 2 April 18th 05 06:56 AM
Duplicate records in Excel Sheidsa Excel Discussion (Misc queries) 1 November 30th 04 12:23 AM


All times are GMT +1. The time now is 06:27 AM.

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"