| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return the column of the next empty cell
Hey guys I think this is a simple one. I have Range
A4:Z4. There can be as many as 26 total values in this range (1 value per cell). There are currently 21 values in Row4, which means currently the last value is in ColumnU. The next data I enter needs to go in ColumnV (Cell V4). Heres my question: What would the formula be to return the next empty Column in Row4? For instance, in this case the formula would need to return the value "V" because the next empty column in Range A4:Z4 is columnV. Todd Huttenstine |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to return first value in a cell that is non empty | Excel Discussion (Misc queries) | |||
| return empty string value if cell is blank | Excel Discussion (Misc queries) | |||
| Return an empty or blank cell value? | Excel Worksheet Functions | |||
| return an EMPTY cell in an IF formula | Excel Discussion (Misc queries) | |||
| Return an empty cell | Excel Discussion (Misc queries) | |||
![Todd Huttenstine[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
