Thread: Last Value in a Range
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Last Value in a Range
"T. Valko" wrote...
For the rightmost number excluding zeros:

=LOOKUP(1E100,1/B7:M7,B7:M7)

Assumes there are no logical values (TRUE) in the range.
....

Why assume? Bypass 'em.

=LOOKUP(1E+300,B7:M7/(B7:M7<0)/(B7:M7<TRUE))
Reply With QuoteReply With Quote