Thread: first and last occurance
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darius Darius is offline
external usenet poster
  
Posts: 41
Default first and last occurance
in range a2:a3500 how to find the row number of first cell which its content
value is less than 0.0 and last value which is less than 0.0?

They can be set in B2 and B3.
Thanks for help
Reply With QuoteReply With Quote