finding highest dollar amount

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

Guest

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.
 
Your data in A2:B200

In cell E2 =MAX(B2:B200)
In cell D2 =INDEX(A2:A200,MATCH(E2,B2:B200,0))

In case of a tie you only get the first one listed though.
 
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

Urgent Need help 4
test a range of dollar amounts to assign a commission value 6
Evaluating values in cells (an Array?) and returning a dollar amount 1
Converting dollars to text 2
from excel to access - a specific question 2
Find Text in VBA if it is IS Nothing then... 2
The Coming Combo Of The CPU And GPU, Ray Tracing Versus Rasterization, And Why Billions Of Dollars I 14
How To Get 1 Million Visitors Without Paying A Dime In Advertising 2

Back
Top