| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find last none empty cell
Hi
i have a worksheet that allows the user to enter data over a range C27 : Z27 What i want to do is check the range and return the last cell that contains a value i have tried several formulas but am getting lost this formula below is the closest i can get to resolving the problem =ADDRESS(ROW(A5),MATCH(<" ",A5:E5)) can anyone help please thanks kevin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to go to next empty cell in a formula | Excel Worksheet Functions | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
