Ranking question

kcross31

New Member
Joined
Jun 21, 2021
Messages
14
Office Version
  1. 365
Platform
  1. Windows
  2. Web
I am trying to create a fluid document that ranks teams by their current total number of points. The image below shows how I have it set up in the spreadsheet. Currently, as teams score points they are automatically updated next to their team name. What I would like is for the Team name with the most points at any given moment be shown in first place in column F (F2). And then have the sheet rank each of the teams and populate the appropriate cell in column F. Is this possible?

1642098241212.png
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Is this what you're looking for?
Book1
ABCDEF
1TeamsPointsPlaceCurrent Team Standings
2Team1761Team2
3Team21002Team5
4Team3833Team10
5Team4664Team9
6Team5955Team3
7Team6796Team13
8Team7657Team6
9Team8708Team1
10Team9849Team8
11Team108910Team4
12Team116011Team7
13Team126512Team7
14Team138013Team11
Sheet2
Cell Formulas
RangeFormula
F2:F14F2=INDEX(A2:A14,MATCH(SORT(B2:B14,1,-1),B2:B14,0))
Dynamic array formulas.
 
Upvote 0
Another option
+Fluff 1.xlsm
ABCDEF
1TeamsPointsPlaceCurrent Team Standings
2Team1761Team2
3Team21002Team5
4Team3833Team10
5Team4664Team9
6Team5955Team3
7Team6796Team13
8Team7657Team6
9Team8708Team1
10Team9849Team8
11Team108910Team4
12Team1160
13Team1265
14Team1380
15
Data
Cell Formulas
RangeFormula
F2:F11F2=INDEX(SORTBY(A2:A14,B2:B14,-1),SEQUENCE(10))
Dynamic array formulas.


@BigBeachBananas have a look at the 11th & 12th place teams in col F with your formula. ;)
 
Upvote 0
Is this what you're looking for?
Book1
ABCDEF
1TeamsPointsPlaceCurrent Team Standings
2Team1761Team2
3Team21002Team5
4Team3833Team10
5Team4664Team9
6Team5955Team3
7Team6796Team13
8Team7657Team6
9Team8708Team1
10Team9849Team8
11Team108910Team4
12Team116011Team7
13Team126512Team7
14Team138013Team11
Sheet2
Cell Formulas
RangeFormula
F2:F14F2=INDEX(A2:A14,MATCH(SORT(B2:B14,1,-1),B2:B14,0))
Dynamic array formulas.
This is exactly what I was looking for, thank you!
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,064
Members
448,545
Latest member
kj9

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top