Need help with max and if formula

[jeremiahw23]

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.

 

[Biff]

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

 

[Dave Peterson]

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.

 

[Biff]

Hint: use a combination of INDEX, MATCH and MAX.

Or read Dave's reply!

Biff

 

[Dave Peterson]

Even a blind squirrel finds an acorn every so often!

 

[Bob Phillips]

wrong group - alt.philosophy.confucianism

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Dave Peterson]

Ahhh. I multiposted to that group! <gd&r>

wrong group - alt.philosophy.confucianism

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Debra Dalgleish]

And I think Bob meant to type - alt.philosophy.confusionism

Ahhh. I multiposted to that group! <gd&r>

 

[Dave Peterson]

Ahem.

Please keep these types of posts here: Alt.Philosophy.Candianism

And I think Bob meant to type - alt.philosophy.confusionism