| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A Macro to find missing serial numbers in a column
In a column, serial numbers are typed as a reference. For example from 1 to
173. How ever actual number of　raws is 175 (obvious by checking raw numbers). 2 numbers are missing. Let say for example 17 and 56 are not typed. What is the easiest way to find these raws? Is there any written MAcro, to find these raws? -- Rasoul Khoshravan Azar Kobe University, Kobe, Japan A Macro to find missing serial numbers in a column |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| find text in column h and total the corresponding numbers if colum | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
Threaded Mode
