Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Equals
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(Score s!$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(Score s!$D$8:Scores!$D$131=2,IF(D10=D11,Scores!$X$8:Scor es!$X$131,1)))," ") where D10 and D11 are the same scores but to no avail. Any help would be greatly appreciated. Thanks. Adam |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Equals
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" wrote in message ... 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(Score s!$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(Score s!$D$8:Scores!$D$131=2,IF(D10=D11,Scores!$X$8:Scor es!$X$131,1)))," ") where D10 and D11 are the same scores but to no avail. Any help would be greatly appreciated. Thanks. Adam |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Equals
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" wrote in message ... 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(Score s!$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(Score s!$D$8:Scores!$D$131=2,IF(D10=D11,Scores!$X$8:Scor es!$X$131,1)))," ") where D10 and D11 are the same scores but to no avail. Any help would be greatly appreciated. Thanks. Adam . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
If cell is left blank, or equals zero, then cell equals a different cell | Excel Discussion (Misc queries) | |||
if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
IF equals this OR this | Excel Worksheet Functions | |||
custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) |