how we can find out any missed number in a series?
 

Please answered as soon as possible.

how we can find out any missed number in a series?
 

=match(full_list, partial_list, 0)

copy down the list

For example:

A1:A100 contains the complete list

C1:C100 contains the list you want to find missing values in

In B1 type: =match(A1, $C$1:$C$100,0)

This will put an #N/A next to any number in A that does not exist in B.

Does that help?

"Excel" wrote:

Please answered as soon as possible.