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

Hi!

Where is the month and how is it entered?

What happens if more than one person has the highest amount and in different
months?

Biff

"gcheatwood" wrote in message
...
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).