Using the IF & MAX function together
 

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.

Using the IF & MAX function 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))

--
Biff
Microsoft Excel MVP


"Excellerated" wrote in message
...
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.

Using the IF & MAX function together
 

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!

"T. Valko" wrote:

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))

--
Biff
Microsoft Excel MVP


"Excellerated" wrote in message
...
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.

Using the IF & MAX function together
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Excellerated" wrote in message
...
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!

"T. Valko" wrote:

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))

--
Biff
Microsoft Excel MVP


"Excellerated" wrote in message
...
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.