Splitting Equals

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
 
B

Bob Phillips

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.
 
A

Adam

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top