Thread: Text in last used cell in a column to another cell.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
  
Posts: 207
Default Text in last used cell in a column to another cell.
=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?


Reply With QuoteReply With Quote