View Single Post
  #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