Thread: How to count the maximum number flanked by zeros
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mandeep Baluja Mandeep Baluja is offline
external usenet poster
  
Posts: 25
Default How to count the maximum number flanked by zeros
way to Go !! It tooks three hours to get this result with the formula.

=IF(IF(A3<0,MAX(OFFSET(A2,,,MATCH(0,A3:A15,0),1), B1))=FALSE,"",IF(A3<0,MAX(OFFSET(A2,,,MATCH(0,A3: A15,0),1),B1)))

Thanks
Mandeep Baluja
Excel Specialist.

Send me your email id I can send you the file tooo.
Reply With QuoteReply With Quote