Thread: Calculating largest gap in a series of consecutive numbers
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Calculating largest gap in a series of consecutive numbers
Hello,

If I understand the question correctly, enter normally into C1
=MAX(0,LOOKUP(2,1/("0"=""&A2:A30),ROW(A2:A30))-LOOKUP(2,1/
(1=A2:A30),ROW(A2:A30)))

Regards,
Bernd
Reply With QuoteReply With Quote