Regarding Duplicates

[showry]

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.

 

[Jacob Skaria]

Suppose you have list A and list B in ColA and ColB starting from row2. In
cell C2 apply the below formula and copy down as required...

=IF(COUNTIF(A:A,B2),"",B2)

 

[showry]

Suppose you have list A and list B in ColA and ColB starting from row2. In
cell C2 apply the below formula and copy down as required...

=IF(COUNTIF(A:A,B2),"",B2)

--
Jacob









- Show quoted text -Thanks dear... it's wworking properly...