track missing numbers


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.

=A1=A2-1