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)

--
Jacob


"showry" wrote:

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.
.

On Mar 2, 2:26*pm, Jacob Skaria
wrote:
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



"showry" wrote:
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.
.- Hide quoted text -

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