Need help with max and if formula
Say you have the names in A1:A100. And the quantity of cars sold in B1:B100.
You could use a formula like:
=index(a1:a100,match(max(b1:b100),b1:b100,0))
to get the first person with the maximum number.
If you could have ties, I think I'd just use Data|Filter|Autofilter on column B
to show the highest number.
jeremiahw23 wrote:
I need to create a cell entry that displays the name of the salesperson who
sold the most cars in the quarter. Use a combination of the €œIF€ and "MAX"
functions to do this. Hint: you will need to use these functions function
multiple times in the same formula to do this.
--
Dave Peterson
|