Last populated cell in a column
Your welcome and glad I could help
Mike
"RedFive" wrote:
Thanks, worked just like I wanted it to
--
RedFive
"Mike H" wrote:
Hi,
=INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A1000))*(A1:A 1000<""))))
or if you know its a number
=LOOKUP(10^23,A:A)
or if you know its text
=MATCH(REPT("z",255),A:A)
Mike
"RedFive" wrote:
I am trying to write a formula that will recognize the last populated cell in
a given column, and then display what is in that cell. Is there a function
that will recognize the last populated cell in a given column?
--
RedFive
|