| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
confirm the missing numbers in a series
help pls.
I have a column of text and numbers with something like this Col. A 1 3 3a 3b 5a 7 I need to gather <among the series the missing numbers in another helper column <note : no decimals, all positive, no gaps... 2 4 6 is there a formula for this in excel ? thanks in advance... -- regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find missing values in a series | Excel Worksheet Functions | |||
| Function for missing data in a series? | Excel Worksheet Functions | |||
| How to find missing numbers in series | Excel Worksheet Functions | |||
| Series Lines Handling of Missing Data | Charts and Charting in Excel | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
Threaded Mode
