number sequence gap
 

I have three columns of info. Date, Check #, and $ amount.
I have a straight list in order of check#. There are several occurances
where there is a gap in the check # sequence.
Is there anyway to put a "*" like on a bank statement each time there is a
gap in the check # sequence??

number sequence gap
 

Suppose your check numbers are in column A, starting in row 2.
Put the following formula in B3 and copy down as far as you need
to go.

=IF(A3<A2+1,"*","")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Judi Mason" wrote in
message
...
I have three columns of info. Date, Check #, and $ amount.
I have a straight list in order of check#. There are several
occurances
where there is a gap in the check # sequence.
Is there anyway to put a "*" like on a bank statement each time
there is a
gap in the check # sequence??