| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find last none empty cell
=ADDRESS(ROW(A5),MAX(IF(ISBLANK(C5:Z5),0,COLUMN(C5 :Z5))))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "kevcar40" wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find last none empty cell
thank you
works a treat kevin |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find last none empty cell
thank you
works a treat kevin |
| Reply |
| 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 | |||
Linear Mode
