| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identifying missing numerical values in a series
In column A I have a series of numbers running from 1001 to 9078. These
numbers run in numerical order, but there are known missing values. For example, the numbers may run 1000, 1001, 1005. In this instance the missing numbers are 1002, 1003 and 1004. It is these missing numbers that I need to identify from the column of numbers running from 1001 to 9078. Could these missing numbers be placed in column C. Any help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filling a reference series in alphabetical order, not numerical | Excel Worksheet Functions | |||
| Identifying when all values in a range are the same. | Excel Discussion (Misc queries) | |||
| identifying colours of existing elements / series | Charts and Charting in Excel | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Find missing values in a series | Excel Worksheet Functions | |||
Threaded Mode
