software

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 quot;*quot; 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(A3lt;gt;A2 1,quot;*quot;,quot;quot;)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Judi Masonquot; gt; wrote in
message
...
gt;I have three columns of info. Date, Check #, and $ amount.
gt; I have a straight list in order of check#. There are several
gt; occurances
gt; where there is a gap in the check # sequence.
gt; Is there anyway to put a quot;*quot; like on a bank statement each time
gt; there is a
gt; gap in the check # sequence??
gt;