title: Excel - Find the biggest gap in a set of numbers?
body: <p>I have a series of numbers<br/>
  0,1,99,5,5,98,9<br/>
  They are unsorted and will remain that way.<br/>
  I cannot use macros.<br/>
  I want the answer 89 from a formula or an array formula.<br/>
  89 is the biggest gap (between 9 and 98) in this series when sorted.<br/>
  I want a formula, no vba, and no sorting my column or row.<br/></p>
  <p>
  I need a formula that sorts the list and subtracts one cell relative to the sorted list and gives the largest difference of the list of differences it creates.
  </p>
  <p>so the list becomes 0,1,5,5,9,98,99<br/>
  subtracts the current from the previous (na,1,4,0,4,89,1)<br/>
  and gives me the max 89.<br/></p>
  <p>
  My list is a column of 7 rows.
  </p>