View Single Post
  #1   Report Post  
gcheatwood
 
Posts: n/a
Default find the max in different columns

I have a spreadsheet for a sales group. I want to be able to format a cell
to find the biggest month of all of the salespeople. then, I want the cell
next to it to state the name of the salesperson who had the highest month.

Example - Beth's totals are in A3 - A15, Valeries are in D3 - D15, Vicki's
are in G3 - G15.
The highest month was in march, it was 63 units, and it belonged to valerie.

So the cell would look like this:
March 63 Valerie

How can I get all three of those results (knowing they have to be in
different cells).