I have a simple spreadsheet that shows ten teams in rows with point totals.
How do I set this up so that the team with the highest total points is always
on top of the list with the other teams in descending order by point valve?

Assumptions...

A1:A10 contains the 'Team Name'

B1:B10 contains the 'Total Points'

Formula...

D1, copied down and over to Column E:

=INDEX(A$1:A$10,MATCH(LARGE($B$1:$B$10-ROW($B$1:$B$10)/10^10,ROWS(D$1:D1)
),$B$1:$B$10-ROW($B$1:$B$10)/10^10,0))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"stevenap" wrote:

I have a simple spreadsheet that shows ten teams in rows with point totals.
How do I set this up so that the team with the highest total points is always
on top of the list with the other teams in descending order by point valve?

Domenic:

That doesn't do what I what. The teams are listed in a7:a16 and the scores
are in m7:m16. I want to have the team with the highest score be moved to
the top with the other teams listed below by point valve. Is this possible?
And THANK YOU!! for your help!

"Domenic" wrote:

Assumptions...

A1:A10 contains the 'Team Name'

B1:B10 contains the 'Total Points'

Formula...

D1, copied down and over to Column E:

=INDEX(A$1:A$10,MATCH(LARGE($B$1:$B$10-ROW($B$1:$B$10)/10^10,ROWS(D$1:D1)
),$B$1:$B$10-ROW($B$1:$B$10)/10^10,0))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"stevenap" wrote:

I have a simple spreadsheet that shows ten teams in rows with point totals.
How do I set this up so that the team with the highest total points is always
on top of the list with the other teams in descending order by point valve?

Try the following array formulas that need to be confirmed with
CONTROL+SHIFT+ENTER, not just ENTER...

O7, copied down:

=INDEX(A$7:A$16,MATCH(LARGE($M$7:$M$16-ROW($M$7:$M$16)/10^10,ROWS(O$7:O7)
),$M$7:$M$16-ROW($M$7:$M$16)/10^10,0))

P7, copied down:

=INDEX(M$7:M$16,MATCH(LARGE($M$7:$M$16-ROW($M$7:$M$16)/10^10,ROWS(P$7:P7)
),$M$7:$M$16-ROW($M$7:$M$16)/10^10,0))

Hope this helps!

In article ,
"stevenap" wrote:

Domenic:

That doesn't do what I what. The teams are listed in a7:a16 and the scores
are in m7:m16. I want to have the team with the highest score be moved to
the top with the other teams listed below by point valve. Is this possible?
And THANK YOU!! for your help!

Domenic:

Thank you very much!!!! This does what I want! Much appreciated!

"Domenic" wrote:

Try the following array formulas that need to be confirmed with
CONTROL+SHIFT+ENTER, not just ENTER...

O7, copied down:

=INDEX(A$7:A$16,MATCH(LARGE($M$7:$M$16-ROW($M$7:$M$16)/10^10,ROWS(O$7:O7)
),$M$7:$M$16-ROW($M$7:$M$16)/10^10,0))

P7, copied down:

=INDEX(M$7:M$16,MATCH(LARGE($M$7:$M$16-ROW($M$7:$M$16)/10^10,ROWS(P$7:P7)
),$M$7:$M$16-ROW($M$7:$M$16)/10^10,0))

Hope this helps!

In article ,
"stevenap" wrote:

Domenic:

That doesn't do what I what. The teams are listed in a7:a16 and the scores
are in m7:m16. I want to have the team with the highest score be moved to
the top with the other teams listed below by point valve. Is this possible?
And THANK YOU!! for your help!