title: Finding a max value in a column based on a previous column in Excel
body: <p>I have an Excel work sheet that holds a list of cures carried out. I would like to create a table on another worksheet withthin the same workbook that will show users what the latest number of a given component is that has been cured. The data is logged like so (other columns not relevant are not shown). I would like a formula that looks down Column B for a part (FIS), then look down Column C and find the highest value in all rows that have FIS in Column B.</p>
  
  <p>Column A / Column B / Column C</p>
  
  <p>Cure Number / Component / Spar No.</p>
  
  <p>49-2013-05-W2R-1    /  FIS  / 10030</p>
  
  <p>36-2013-06-W2R-2    /  FOP  / 10030</p>
  
  <p>46-2013-16-W2R-1    /  FOS  / 10030</p>
  
  <p>32-2013-05-W2R-2    /  RIP  / 10030</p>
  
  <p>I'm sure this is simple but not conversant on some of formulas like Vlookup, match, index etc.</p>
  
  <p>47-2013-23-W2R  /  RIS /    10030</p>