title: Select max of each group with its associated values
body: <p>I have a large table formatted like so:  </p>
  
  <pre><code>+-----+-------+-------+
  | id  | count | group |
  +-----+-------+-------+
  | 123 | 37    | a     |
  +-----+-------+-------+
  | 121 | 26    | a     |
  +-----+-------+-------+
  | 442 | 33    | a     |
  +-----+-------+-------+
  | 923 | 55    | b     |
  +-----+-------+-------+
  | 783 | 12    | b     |
  +-----+-------+-------+  
  </code></pre>
  
  <p>My goal output would select the max count as well as the id associated with the max count for each group. Is there an array function that can do this? This array function gets me the max count, but it's not always distinct so i'm unsure how to grab the id as well:  </p>
  
  <pre><code>{=MAX(IF(C:C=C1,B:B))}  
  </code></pre>
  
  <p>So this would check the group in the 3rd (C) column and return the max count in the 2nd (B) column, but how can i grab the first (A) column as well?</p>