Need help with max and if formula
Hint: you do not need to "use these functions function multiple times in the
same formula to do this."
Hint: use a combination of INDEX, MATCH and MAX.
Biff
"jeremiahw23" wrote in message
...
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.
|