number sequence gap

J

Judi Mason

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??
 
C

Chip Pearson

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





message
news:[email protected]...
 
Top