| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
finding highest dollar amount
I would like a formula that will draw out of a list of sales people and their
sales the top sale and who that person is: For example if these are my sales: Brian 72.9 Brian 104.77 Brian 119.99 Brian 229.97 Brian 142.84 Brian 259.87 Cassi 301.95 Cassi 62.9 Cassi 49.95 Cassi 139 Chad 94.99 Chad 76.9 Chris 283.98 Chris 34.95 Chris 133.97 Chris 249.99 Chris 1499.87 Clarissa 98.85 Clarissa 125.95 Clarissa 62.9 I would like the formula to draw out Chris in one cell and $1499.87 in the cell next to his name. Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| this should be easy...highest value in a row | Excel Discussion (Misc queries) | |||
| Dollar Bill Chart | Charts and Charting in Excel | |||
| To find a combination of numbers that equal a set amount? | Excel Discussion (Misc queries) | |||
| Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) | |||
| Conditional Format With SUMIF | Excel Worksheet Functions | |||
Threaded Mode
