| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find missing sequential numbers
Hello, I'm looking for a way to quickly find what numbers are missing in
column B. I can sort them ascending, but how do I find if there are missing numbers? 1 2 3 5 6 7 9 I need to know 4 and 8 are missing. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I find duplicate numbers within a column? | Excel Worksheet Functions | |||
| Sequential Numbers | Excel Discussion (Misc queries) | |||
| sequential numbers | Excel Worksheet Functions | |||
| How do i identify missing numbers in a sequential list | Excel Discussion (Misc queries) | |||
| How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) | |||
Threaded Mode
