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

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

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


.