Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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). |
#2
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
Perform functions on the result of adding two columns | Excel Worksheet Functions | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
two columns of numbers, need to sort/filter to find one number th. | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |