title: Excel formula for finding second earliest to the earliest date in a column
body: <p>I have a data query in Excel that returns multiple rows of information for a single employee. The employee are sorted by an EmployeeID, and the data contains Pay Rates and Dates. </p>
  
  <p>I have sorted the information by date descending in order to give me the first Pay Rate for an employee to put within a VLookUp for another sheet in my workbook. Now I need a formula to give me to next date in line so I can find the second earliest date in the range. Can this be done?</p>
  
  <pre><code>Data example:
  1255  7.50   06/11/2012
  1255  7.00   09/11/2011
  1255  6.50   05/12/2011
  2548  12.50  03/02/2012
  2548  12.00  01/13/2012
  </code></pre>