Posted to microsoft.public.excel.misc

Beth[_3_]

external usenet poster

Posts: 3

Indicate missing number in a sequence

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
find missing numbers in a sequence	kaytoo	Excel Discussion (Misc queries)	1	June 13th 06 04:43 PM
Indicate missing number in a sequence (Part II)	mmock	Excel Discussion (Misc queries)	3	February 22nd 06 07:13 PM
indicate a missing number in a sequence	mmock	Excel Discussion (Misc queries)	13	February 22nd 06 03:23 AM
How do I find a missing number in a sequence of numbers?	Nash	Excel Worksheet Functions	2	August 11th 05 04:22 AM
Finding numbers missing from a sequence	andy	Excel Discussion (Misc queries)	3	April 8th 05 04:16 PM

All times are GMT +1. The time now is 02:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us