Splitting Equals
in [General]
|
From: Adam on 14 Apr 2010 07:42 Using the following array formula I am identifying the top five largest points scores with specific criteria =LARGE(IF(Scores!$F$8:Scores!$F$131="Boy",IF(Scores!$D$8:Scores!$D$131=2,Scores!$Q$8:Scores!$Q$131)),3) In the next column I have a VLOOKUP to fiind the participants names. Where I have two participants with the same score, one name shows up twice for position 3 and 4. I have lots of other columns which I can use to split the participants and have tried =LARGE(IF(Scores!$F$8:Scores!$F$131="Boy",IF(Scores!$D$8:Scores!$D$131=2,IF(D10=D11,Scores!$X$8:Scores!$X$131,1)))," ") where D10 and D11 are the same scores but to no avail. Any help would be greatly appreciated. Thanks. Adam
From: Bob Phillips on 14 Apr 2010 09:00 Adam, Can you show us what the table looks like? I am unclear because I assume that you are looking up the score, but I cannot see how that gets you the name. Seeing the data and knowing what cells they are in would help. -- HTH Bob "Adam" <Adam(a)discussions.microsoft.com> wrote in message news:78517755-4F93-41E9-A997-A627EAF9ADDD(a)microsoft.com... > Using the following array formula I am identifying the top five largest > points scores with specific criteria > > =LARGE(IF(Scores!$F$8:Scores!$F$131="Boy",IF(Scores!$D$8:Scores!$D$131=2,Scores!$Q$8:Scores!$Q$131)),3) > > In the next column I have a VLOOKUP to fiind the participants names. > > Where I have two participants with the same score, one name shows up twice > for position 3 and 4. > > I have lots of other columns which I can use to split the participants and > have tried > > =LARGE(IF(Scores!$F$8:Scores!$F$131="Boy",IF(Scores!$D$8:Scores!$D$131=2,IF(D10=D11,Scores!$X$8:Scores!$X$131,1)))," > ") where D10 and D11 are the same scores but to no avail. > > Any help would be greatly appreciated. > > Thanks. Adam
From: Adam on 14 Apr 2010 09:58 Hi Bob Not sure how to post a table. The first column looks purely to find the largest points score given the parameters. The second column concatenates this points score with the parameters for instance (122-6-Boy) where 122 is points, 6 is grade, Boy is gender. The third column looks to a lookup table where the left column has the same concatenation and he right column has the name. I appreciate this may be a longwinded approach and if you have any thoughts that would be great. Ultimately, the only problem I currently have is where two participants have the same concatenated lookup. Thanks "Bob Phillips" wrote: > Adam, > > Can you show us what the table looks like? I am unclear because I assume > that you are looking up the score, but I cannot see how that gets you the > name. Seeing the data and knowing what cells they are in would help. > > -- > > HTH > > Bob > > "Adam" <Adam(a)discussions.microsoft.com> wrote in message > news:78517755-4F93-41E9-A997-A627EAF9ADDD(a)microsoft.com... > > Using the following array formula I am identifying the top five largest > > points scores with specific criteria > > > > =LARGE(IF(Scores!$F$8:Scores!$F$131="Boy",IF(Scores!$D$8:Scores!$D$131=2,Scores!$Q$8:Scores!$Q$131)),3) > > > > In the next column I have a VLOOKUP to fiind the participants names. > > > > Where I have two participants with the same score, one name shows up twice > > for position 3 and 4. > > > > I have lots of other columns which I can use to split the participants and > > have tried > > > > =LARGE(IF(Scores!$F$8:Scores!$F$131="Boy",IF(Scores!$D$8:Scores!$D$131=2,IF(D10=D11,Scores!$X$8:Scores!$X$131,1)))," > > ") where D10 and D11 are the same scores but to no avail. > > > > Any help would be greatly appreciated. > > > > Thanks. Adam > > > . >
|
Pages: 1 Prev: Excel. How do I remove 1,000 mailed addresses from list of 2,265? Next: Pivot Field List |