Using the IF & MAX function together

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

Guest

I need to have a cell give a name of a person who has the most sales. there
is a column with the names of the people and another with the vales or
totals. I am told I can use the IF and MAX function, but I must use them
several times in the same formula to do this. I can use them separately, but
I don't know how to use them together.
 
Try this:

A1:A10 = names
B1:B10 = sales figures

To get the name with the highest sales:

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))
 
You're a genius! I think there is a way to do it with just the IF & MAX
functions, but this works great. I am taking a basic Excel class and we
haven't gotten to this part yet in the class and are just doing basic
functions, but this works.

I plugged it into my spreadsheet and it worked great.

Thanks for your help!
 
Back
Top