Thread: How do I choose the last nonblank cell in a ROW?
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 How do I choose the last nonblank cell in a ROW?
Hi,

This returns the last populated cell in row 2 of sheet 1

=LOOKUP(2,1/(Sheet1!2:20),Sheet1!2:2)

Mike

"DaChris" wrote:

I have a row of sales data by month. I need to create a link in a seperate
worksheet to access the last data in the row. The link must differenate
between 0 as data and a blank cell as no data.
Reply With QuoteReply With Quote