title: Excel VBA Find String with largest value in adjacent cell
body: <p>I have a column with some text and another with numbers as below:</p>
  
  <pre><code>--------  -----
  | GREY |  | 4 |
  --------  -----
  | BLUE |  | 3 |
  --------  -----
  | BLUE |  | 5 |
  --------  -----
  | GREY |  | 1 |
  --------  -----
  </code></pre>
  
  <p>I'd like to find all the cells containing a certain string (let's say "Blue", see above), then the one with the highest value in the adjacent cell (which would give "5" here).</p>
  
  <p>I know the FIND method and also how to get the largest value of a range (Application.WorksheetFunction.Max) but I have no idea how to combine both.</p>
  
  <p>Could anybody help me please?
  Thank you in advance and sorry for my english!</p>