title: Select column to the left of max in a row
body: <p>I want to be able to select the column to the left of the column that is the max in a row. Basically, I have the text there, so it would be something like this:</p>
  
  <pre><code>0  A           B
  1  Tomatoes:   10
  2  Apples:     5
  3  Bananas:    8
  </code></pre>
  
  <p>"select column to the left of the max of b1 to b3"
  I know it's max(b1:b3) to get the max, but how do I select the max? By the way, this is how I'm going to set it up:</p>
  
  <p>There are the most of: "Tomatoes"</p>
  
  <p>Should be the answer, not 10, which it would normally return if I'd just use the max formula.</p>