| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Display next available number
Hi I have a spreadsheet with sequential numbers from 100 thru 2300 in a column.
There will be numbers missing in it like #269 or #400 or #1350-#1420 I need a formula that looks at column A and then displays the next available number. for instance Let say column A has the numbers 1 - 10 but the number 4 and number 9 is missing. I want the formula to display the number 4 then if I enter in the number 4 in column A it will display the number 9. Can this be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display total above certain number and display | Excel Discussion (Misc queries) | |||
| Display a 16 digit number | Excel Discussion (Misc queries) | |||
| Display row number of the last value in a column | Excel Worksheet Functions | |||
| How to display the number zero at the beginning of a number when . | New Users to Excel | |||
| Number Display | Excel Programming | |||
Threaded Mode
