find the max in different columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find MAX of column from using 2 criterias 3
Nested If 2
Calculating Differences between columns in a Pivot Table 3
Calculating bonuses - but not a VLOOKUP or CEILING? 6
using formula to pull data from different worksheets 4
Find 3 numbers +/- 26 rows from each other 2
Copying from different files into 1 1
How do I average a row of 13 enries using the 8 highest in value. 2

Back
Top