Hello,
I need to find a formula to return the last entry (which could be text or a number) in a specified column. I'm stuggling to find the solution - excel help is no good, and I can only find one website that might show me how to do it but using a load of INDIRECTs and ADDRESSes seems unnecessarily complicated.
It says:
To find the last entry in the second column of DataRange2, use the following Array Formula:
=INDIRECT(ADDRESS(MAX((DataRange2<>"")*ROW(DataRange2)),
COLUMN(DataRange2)+1,4))
So is that the only way to do it or is there a simpler way?
Thanks in advance,
Chris.
I need to find a formula to return the last entry (which could be text or a number) in a specified column. I'm stuggling to find the solution - excel help is no good, and I can only find one website that might show me how to do it but using a load of INDIRECTs and ADDRESSes seems unnecessarily complicated.
It says:
To find the last entry in the second column of DataRange2, use the following Array Formula:
=INDIRECT(ADDRESS(MAX((DataRange2<>"")*ROW(DataRange2)),
COLUMN(DataRange2)+1,4))
So is that the only way to do it or is there a simpler way?
Thanks in advance,
Chris.