| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find missing numbers in a column
Hi,
I have a column of 1277 sequenced data points numbered 1 thru 12 (representing months) which repeat throughout the column. Some of the numbers (months) are missing over numerous years and I need to locate these numbers and replace the missing number with a blank column. Is there a very simple way to do this?? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A Macro to find missing serial numbers in a column | Excel Discussion (Misc queries) | |||
| find missing numbers in a sequence | Excel Discussion (Misc queries) | |||
| find missing numbers in a sequence | Excel Discussion (Misc queries) | |||
| Find missing sequential numbers | New Users to Excel | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
Threaded Mode
