title: Selecting the max with a condition in excel
body: <p>I have a range in excel with dates and values</p>
  
  <p><a href="http://lh4.ggpht.com/_i-hI_3gfy08/SoSIopeZUZI/AAAAAAAABEk/KjFnq57VTUc/table.png" rel="nofollow noreferrer">http://lh4.ggpht.com/_i-hI_3gfy08/SoSIopeZUZI/AAAAAAAABEk/KjFnq57VTUc/table.png</a>
  EDIT:image added</p>
  
  <p>I want to select the MAX value from the HIGH column for each YEAR (2009 would return 404, 2008 would return 390)</p>
  
  <p>I've done something similar but it's using SUMIF, not MAX.</p>
  
  <p>Any excel people in here that can help me out?</p>