| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
serial numbers how to find gaps
Hello,
How can I find gaps in a column of serial numbers, gaps can be of one number or more, gaps can appear several time in the same line. Example: 10010 10011 10012 10014 10015 10018 (gaps found are 10013, 10016, 10017) I need to present those gaps in any possible way. Thanks, Doron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting&Sorting multiple serial numbers per machine type | Excel Discussion (Misc queries) | |||
| Find all numbers in database that end in... | Excel Worksheet Functions | |||
| find sum in list of of numbers | New Users to Excel | |||
| 'find' somtimes can't find numbers. I folowd the 'help' instructi. | Excel Worksheet Functions | |||
| Find similar numbers from two columns of numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
