| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| A new sequence number in file everytime it is opened | Excel Worksheet Functions | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| Continuing Number Sequence | Excel Discussion (Misc queries) | |||
Threaded Mode
