Automatic Records Table Sort?

[ojstimpy]

How can I have the records table at the top left automatically sort by points? Example: Benny would be in 4th place because of the amount of points he has related to others.

[brokenbiscuits]

It's not super elegant, but it'll do the job.

This will sort the table by points, then (if a tie) win %, then goal difference, then goals scored. Note the original table has been moved to rows 81-88 (and is probably best hidden), then a new table added which uses VLOOKUPs to pull the data back from the original with the help of a new column (A).

I hope this helps.

[ChemistB]

BrokenBiscuit's solution is good but will break down if there is a tie with the points.

Using BB's spreadsheet, in AK82 dragged down
=RANK(N82,$N$82:$Q$88)+COUNTIF($N$82:N82,N82)-1
This gives a unique ranked number to each individual. In case of a tie, the first person gets the higher number.

Then in C15 dragged down
=INDEX($C$82:$C$88,MATCH(ROW(A1),$AK$82:$AK$88,0))
works like VLOOKUP but less restrictive (no longer need the values BB put into A82:A88.

Then replace the formulas in N15 dragged down
=VLOOKUP($C15,$C$82:$AI$88,COLUMN()-2,FALSE)
Does that work for you?

[ojstimpy]

Thank you so very much both you guys. Question, any way to preserve the individual colors of the names?

[ChemistB]

No easy way. It would require some VBA programming.