| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help with max and if formula
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Need help with max and if formula
Hint: use a combination of INDEX, MATCH and MAX.
Or read Dave's reply! Biff "Dave Peterson" wrote in message ... 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 ?oIF? 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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Need help with max and if formula
Even a blind squirrel finds an acorn every so often!
Biff wrote: Hint: use a combination of INDEX, MATCH and MAX. Or read Dave's reply! Biff "Dave Peterson" wrote in message ... 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 ?oIF? 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 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Need help with max and if formula
wrong group - alt.philosophy.confucianism
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dave Peterson" wrote in message ... Even a blind squirrel finds an acorn every so often! Biff wrote: Hint: use a combination of INDEX, MATCH and MAX. Or read Dave's reply! Biff "Dave Peterson" wrote in message ... 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 ?oIF? 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 -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Need help with max and if formula
Ahhh. I multiposted to that group! <gd&r
Bob Phillips wrote: wrong group - alt.philosophy.confucianism -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dave Peterson" wrote in message ... Even a blind squirrel finds an acorn every so often! Biff wrote: Hint: use a combination of INDEX, MATCH and MAX. Or read Dave's reply! Biff "Dave Peterson" wrote in message ... 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 ?oIF? 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 -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Need help with max and if formula
And I think Bob meant to type - alt.philosophy.confusionism
Dave Peterson wrote: Ahhh. I multiposted to that group! <gd&r Bob Phillips wrote: wrong group - alt.philosophy.confucianism -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dave Peterson" wrote in message ... Even a blind squirrel finds an acorn every so often! Biff wrote: Hint: use a combination of INDEX, MATCH and MAX. Or read Dave's reply! Biff "Dave Peterson" wrote in message ... 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 ?oIF? 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 -- Dave Peterson -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Need help with max and if formula
Ahem.
Please keep these types of posts he Alt.Philosophy.Candianism Debra Dalgleish wrote: And I think Bob meant to type - alt.philosophy.confusionism Dave Peterson wrote: Ahhh. I multiposted to that group! <gd&r Bob Phillips wrote: wrong group - alt.philosophy.confucianism -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dave Peterson" wrote in message ... Even a blind squirrel finds an acorn every so often! Biff wrote: Hint: use a combination of INDEX, MATCH and MAX. Or read Dave's reply! Biff "Dave Peterson" wrote in message ... 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 ?oIF? 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 -- Dave Peterson -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
