title: Returning entry from an array that fits a range condition
body: <p>Is there a way to have a cell in Excel 2007 view through an array of six numbers and return the highest of any of the numbers that fit into a specified range?  </p>
  
  <p>My particular numbers in the array are <code>22 18 14 10 7 4</code> and my range is <code>6 to 12</code>. I was thinking of creating a separate column with the AND function to simplify some steps but I can't make it work.</p>