Need help with max and if formula jeremiahw23 03.09.2006 01:01:01 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.

Re: Need help with max and if formula "Biff" <biffinpitt[ at ]comcast.net> 03.09.2006 02:16:42 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" <jeremiahw23[ at ]discussions.microsoft.com> wrote in message news:789DA4A4-9515-4EEF-BF12-606CAAFEBDF9[ at ]microsoft.com... [Quoted Text] >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. >

Re: Need help with max and if formula Dave Peterson <petersod[ at ]verizonXSPAM.net> 03.09.2006 02:20:26 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: [Quoted Text] > > 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

Re: Need help with max and if formula "Biff" <biffinpitt[ at ]comcast.net> 03.09.2006 02:29:56 [Quoted Text] >Hint: use a combination of INDEX, MATCH and MAX. Or read Dave's reply! Biff "Dave Peterson" <petersod[ at ]verizonXSPAM.net> wrote in message news:44FA3BEA.D722CF73[ at ]verizonXSPAM.net... > 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

Re: Need help with max and if formula Dave Peterson <petersod[ at ]verizonXSPAM.net> 03.09.2006 12:22:31 Even a blind squirrel finds an acorn every so often! Biff wrote: [Quoted Text] > > >Hint: use a combination of INDEX, MATCH and MAX. > > Or read Dave's reply! > > Biff > > "Dave Peterson" <petersod[ at ]verizonXSPAM.net> wrote in message > news:44FA3BEA.D722CF73[ at ]verizonXSPAM.net... > > 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

Re: Need help with max and if formula "Bob Phillips" <bob.NGs[ at ]somewhere.com> 03.09.2006 12:57:35 wrong group - alt.philosophy.confucianism -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dave Peterson" <petersod[ at ]verizonXSPAM.net> wrote in message news:44FAC907.605387CB[ at ]verizonXSPAM.net... [Quoted Text] > 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" <petersod[ at ]verizonXSPAM.net> wrote in message > > news:44FA3BEA.D722CF73[ at ]verizonXSPAM.net... > > > 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

Re: Need help with max and if formula Dave Peterson <petersod[ at ]verizonXSPAM.net> 03.09.2006 13:47:41 Ahhh. I multiposted to that group! <gd&r> Bob Phillips wrote: [Quoted Text] > > wrong group - alt.philosophy.confucianism > > -- > HTH > > Bob Phillips > > (replace somewhere in email address with gmail if mailing direct) > > "Dave Peterson" <petersod[ at ]verizonXSPAM.net> wrote in message > news:44FAC907.605387CB[ at ]verizonXSPAM.net... > > 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" <petersod[ at ]verizonXSPAM.net> wrote in message > > > news:44FA3BEA.D722CF73[ at ]verizonXSPAM.net... > > > > 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

Re: Need help with max and if formula Debra Dalgleish <dsd[ at ]contexturesXSPAM.com> 03.09.2006 14:17:28 And I think Bob meant to type - alt.philosophy.confusionism Dave Peterson wrote: [Quoted Text] > 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" <petersod[ at ]verizonXSPAM.net> wrote in message >>news:44FAC907.605387CB[ at ]verizonXSPAM.net... >> >>>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" <petersod[ at ]verizonXSPAM.net> wrote in message >>>>news:44FA3BEA.D722CF73[ at ]verizonXSPAM.net... >>>> >>>>>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

Re: Need help with max and if formula Dave Peterson <petersod[ at ]verizonXSPAM.net> 03.09.2006 15:09:01 Ahem. Please keep these types of posts here: Alt.Philosophy.Candianism Debra Dalgleish wrote: [Quoted Text] > > 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" <petersod[ at ]verizonXSPAM.net> wrote in message > >>news:44FAC907.605387CB[ at ]verizonXSPAM.net... > >> > >>>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" <petersod[ at ]verizonXSPAM.net> wrote in message > >>>>news:44FA3BEA.D722CF73[ at ]verizonXSPAM.net... > >>>> > >>>>>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