G
gcheatwood
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).
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).