Thread: Finding next number in a series
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Iriemon Iriemon is offline
external usenet poster
  
Posts: 89
Default Finding next number in a series
I have a series of numbers in one column (sample):

1
2
4
5
7
16


What formula would find the smallest available number? In other words how
would I find "3"?


Reply With QuoteReply With Quote