Posted by Owen Rodrigues on July 20, 2001 10:42 AM
how to find missing numbers in a column of running numbers
Posted by faster on July 20, 2001 11:06 AM
Assuming running numbers are in Column A and start in Row 1. You can use a TRUE/FALSE test. Paste the following formula in cell B2 and copy it down as needed.