View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
showry showry is offline
external usenet poster
 
Posts: 5
Default Regarding Duplicates

Hi All,

How are u? i have a small query about find the missed numbers in two
different lists.

List A list B
1 1
2 5
3 6
6 7
9 8
4 3
7 10
14 9
5 20
10 17
15 14
12 13
13
8
11

I want to find numbers which is not in "list A", Which is in "List B".
in the above example 17 and 20 are the volumes which is not in "List
A" and is there in "List B". i need all new arrived number in one more
list.


Thanks and Regards,
Anil.