Posted to microsoft.public.excel.misc

SiH23

external usenet poster

Posts: 48

Calculating missing numbers

I have a list of numbers from 1 to 1000 in Column A. Some of the numbers are
missing; for example they may run 1, 2 3, 7 etc.

I need a formula that will calculate the missing numbers and place them in
Column B.

Many thanks in advance.

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
Row Numbers Missing	denisej77	Excel Worksheet Functions	1	November 18th 08 02:21 PM
Get Missing Numbers	rc	Excel Discussion (Misc queries)	2	December 4th 07 09:50 PM
I need help calculating averages with missing values?	avg w/ missing #s	Excel Discussion (Misc queries)	2	July 3rd 06 09:58 PM
to find missing serial numbers in randomly generated numbers	B.H. Hadi	Excel Worksheet Functions	2	December 1st 05 10:56 PM
Missing row numbers, HELP !!!!	Tony	Excel Discussion (Misc queries)	2	August 17th 05 02:27 AM

All times are GMT +1. The time now is 12:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us