Missing Cheque numbers in a bank book
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...
|