Regarding Duplicates

  • Thread starter Thread starter showry
  • Start date Start date
S

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.
 
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)
 
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...
Click to expand...
 
Back
Top