Thread: Last cell with data in a range
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ziggy Ziggy is offline
external usenet poster
  
Posts: 47
Default Last cell with data in a range
On Mar 24, 9:31*pm, "Ashish Mathur" wrote:

Or this



=INDIRECT("N"&MAX(IF($N$80:$N$122<0,ROW($N$80:$N$ 122))))

Substitute the "N" for your column and also adjust the ranges.
Reply With QuoteReply With Quote