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