Text in last used cell in a column to another cell.
It worked. Thank you very much.
"Gaurav" wrote:
=LOOKUP(2,1/(A1:A65535<""),A1:A65535)
"rdp" wrote in message
...
I need a formula that will allow me to show the text in the last cell of a
column in another cell at the top of that same column. I have found one
that
works for numbers but not text.
Any suggestions?
|