Thread: Finding next number in a series
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Finding next number in a series
Hello,

Array-enter
=INDEX(ROW(INDIRECT(MIN(A1:A6)&":"&MAX(A1:A6))),MA TCH(TRUE,ISNA(MATCH(ROW(INDIRECT(MIN(A1:A6)&":"&MA X(A1:A6))),A1:A6,0)),
0))

Regards,
Bernd
Reply With QuoteReply With Quote