Forum Discussion
Return the address of last cell by formulas
I don't think that's possible, at least with formulae only. Let assume in new sheet we have data as
Ctrl+End forwards us on A10. Let delete values in few latest cells and press Ctrl+End again
It forwards us on A10. To Del on cells is not enough, we shall use Clear -> Clear All. Otherwise, especially within workbook with which you worked long enough, Ctrl+End forwards us on unpredictable position. More exactly on the last cells which ever had data.
Perhaps that's not what you are looking for and the task to take position of last non-blank cell. For one column that's easy
In other cases that's more complex, but could be possible. More logic is to be defined what we would like to receive. For example, here
Ctrl+End positions us on D10. But what we'd like to find, C8 or A6? And if in column A we have values till A11?
Bottom line, more concrete question for more concrete task is desirable.