I want to make three tables using three different data sources in my sheet

First, let me preface by saying I"m a basketball coach, not a computer "guy"

please see attached sheet

I want to take the values in Column U, attach the names in Column A, and rank from Highest to Lowest

Then I want to do the same with Column V/Column A
And then again with Column W/Column A

And then create 3 tables within the document that display the top 5 in each category.

It's already done, but by hand. Is there a way to automatically set this up?
See A27-A32 for what I want done automatically

thanks in advance. hope I posted this in the right spot.

Chris

Hi and welcome to the forum

Unless you want to get a million emails, it would be better if you did not post personal info like email addresses, not all members have the best intentions, unfortunately

OK on to your question.

1st, change the formula in U to this, to get rid of the error messages...
=IF(T5=0,0,S5/T5)

Then use this to get the ranking...
=LARGE($U$5:$U$18,ROW(A1)) copied down

to pull out the names, use this...
=INDEX($A$5:$A$18,MATCH(Z5,$U$5:$U$18,0))
(I used column Z for the rankings,)

Maybe this will help or give you some ideas:

you need to add a tie-breaker to the scores. Something like this, copied down...
=U5+COUNTIF($U$5:U5,U5)/100
and then use that for the index with this...
=IF(A5="","",INDEX($U$5:$U$18,MATCH(LARGE($Y$5:$Y$18,ROW()-4),$Y$5:$Y$18,0)))
and for the name...
=IF(A5="","",INDEX($A$5:$A$18,MATCH(LARGE($Y$5:$Y$18,ROW()-4),$Y$5:$Y$18,0)))

With all these statistics on each player, what does the NBA use to break ties?

What statistic is most important? Use the difference in important statistics to break ties.

If performance differences can't be used to break a tie, the solution offered by FDibbins is pretty good.

Sorry, I should have explained better. Take a look at the attached, I have l;eft your tables there for comparison, and added mine to the right of them. They are based on 3 helper columns (Y:AA), which you can hide and/or move elsewhere if you want

sure hing. Hopefully that was what you wanted?

Its just practice (and too much free time in here lol)

see if the attached gives you what you wanted? I had to adjust the bottom table references to the "new" tables

Here is the amendment to the top 5.

LOL duh, well done ndm, that list is already ranked - I must have had my head you-know-where

You rightly assumed that I has used the most simple (best--KISS principle) when in fact I made a boo-boo in using the large function. It was unnecessarily complicated and when you submitted the nice formula to eliminate ties, the weakness in my process became evident.

Nice working with you.

and the OP benefited, so everyone wins team work rules!!

You have that right!

You're welcome. Thank you for the feedback and have fun