title: Conditional Min and Max in Excel 2010
body: <p><img src="https://i.stack.imgur.com/Md9CR.jpg" alt="enter image description here"></p>
  
  <p>I would like to find Min and Max of Quantity (Column 2) based on Type (coloumn 1), is it possible to have this done?</p>
  
  <p>I have tried this but the result was unexpected 
  <a href="https://stackoverflow.com/questions/10746792/excel-find-min-max-date-in-a-range-if-it-matches-criteria-of-other-columns">Similar question</a></p>