number sequence gap

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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]...
 
Back
Top