Thread: Return last cell in range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Return last cell in range
Hi,

Lookup what?

Number
=LOOKUP(6.022*10^23,P4:BM4)

text
=LOOKUP(REPT("z",255),P4:BM4)

Mike

"puiuluipui" wrote:

Hi, i need in "F4" a formula that return the last written cell from "P4:BM4"

Can this be done?
Thanks!
Reply With QuoteReply With Quote