Thank You very much it worked but i need one more from you...

i also want to the the missing cheque number instead
of Missing/ Duplicate, And If there is any Duplication of cheque Can i get
this using any formula...


"Gary''s Student" wrote:

In C2 enter:

=IF(B2-B1=1,"","MISSING OR DUPLICATE") and copy down

This will catch BOTH missing numbers and duplicate numbers.
--
Gary''s Student - gsnu200814


"Kumar" wrote:

I Want to know the Missing Cheque no.'s according to the date and my data is
as Follows:-
A B
03-04-2008 44479
04-04-2008 44480
05-04-2008 44480
04-04-2008 44482
05-04-2008 44483
Here "A" Column Contains the Cheque date and B Column Contains Cheque no.,
Now I want the Missing Cheque no.'s by considering the Dates. Can any one
help me with a Formula...