Thanks for replying and i also want to the the missing cheque numbers instead
of Missing/ Duplicate, And If there is any Duplication of cheque with
different dates Can i get this using any formula...

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