Search and display

[Jabbitar]

Hi,

I don't know exactly what the function that I am after is, but, what I am trying to do is this:

- Search columns E2:A11 and sort from highest to lowest.
- Place results of the TEAM NAME (Columns A2:A11) representing the highest to lowest in column B16:B25.

I don't know if it makes sense, but I have uploaded a sample for you.

As you can see, this will need to be done for multiple columns, can you guys help me out please?

Thanks.

[teylyn]

Hi,

in cell B16 enter

=LARGE($E$2:$E$11,$A16)

copy down. This will put the largest value in rank 1

If you want the smallest value in rank one, use

=SMALL($E$2:$E$11,$A16)

Adjust the range for the other columns.

does that do it for you?

[Jabbitar]

Nope, it just displays "1" :|

I'm not sure what function to use for this, its kind of annoying! :D

OK, relooking at it it displays the numbers, can I then reference it so it shows the TEAM, not the number?

[teylyn]

Hi,

for your AST column try this

=INDEX($A$2:$O$11,MATCH(LARGE($K$2:$K$11,$A16),$K$2:$K$11,0),1)

I chose the AST column since all numbers are different, thus unique. The formula does return duplicates and triplicates (and more) if a number occurs more than once, like in FG%, but I'm sure there is a solution. Still working on it.

[Jabbitar]

Thanks, it works perfectly. I just changed the columns in the formula, and made sure that the data actually was different (the percentages) in th eother tables, and it worked wonderfully. Thanks for your help