Thank you for your help on this. It is not working. The header is on A1 and
the first data starts from A2. Where do I need to start typing the formula
(the first formula)?

Thank you,
Beth

"Ragdyer" wrote:

Would this work for you?

With your numbers in A1 to A8,
enter this in B2 and copy down:

=IF(A1+1=A2,"",A1+1)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Beth" wrote in message
...
can somone please assist me what formula I can use to find the missing in
a
sequence number?

see example below. How could I find the missing 1327, 1330 and 1333?

Order #
1325
1326
1328
1329
1331
1332
1334
1335

Any help will be appreciated.

Thank youj,
Beth