Hi Beth

I think you need to change Ragdyer's formula to this if you have a header in
A1and place it in B3, then copy down. You will need to input the first value
in B2 which is 1325.
=IF(A2+1=A2,"",A2+1)

--
HTH

Appreciate that you click the Yes button below if this posting is helpful

cheers, francis
"Beth" wrote in message
...
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