Missing Cheque numbers in a bank book

K

Kumar

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

Bernard Liengme

Please give us more. You seem to have two cheques with number 4480
Is this a typo or is 44481 the example of a missing cheque
What does this mean: Now I want the Missing Cheque no.'s by considering the
Dates
Is there a blank in that column when the cheque is 'missing'?
OR do you want to know how many cheques have dates that are after 03/04/08,
how many after 04/03/08, etc
Sorry to be dense
best wishes
 
G

Gary''s Student

In C2 enter:

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

This will catch BOTH missing numbers and duplicate numbers.
 
K

Kumar

Kumar said:
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...
 
K

Kumar

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

Kumar

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

Gary''s Student

=if(b2-b1=1,"",if(b2=b1,"cheque duplicate","cheque number " & b2-1 & " is
missing"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top