| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find the first blank cell in a range and return me it's position
Hi,
in my invoice sheet I want to look up on the sales sheet the first blank cell in a range (c10:c500) and return me the cell adjacent to the right of it i.e the formual finds c20 is the first blank cell and it returns me the cell to the right, the next invoice number avaiable, 121 anyone any ideas how to achieve this please thanks steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| find a cells from a range of cell | Excel Worksheet Functions | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
| Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions | |||
Threaded Mode
