Splitting Equals

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

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
 
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.
 
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
 
Back
Top