Ranking question

[kcross31]

Hello, I am currently working on a fluid document and I'm stumped on how to achieve a ranking output. I have my workbook currently set to calculate totals in one worksheet and then populate accordingly on a master sheet. But I would like to then rank those outputs and show the name of the team with the highest ranking score. For example, there are 10 teams in column A, their score populates automatically next to their name in column B. I'd like column B ranked with the highest score to the lowest and populate the cells in column F with the names of the teams only in order. I'm not sure if that makes sense or is possible.

 

[Sufiyan97]

Hello, I am currently working on a fluid document and I'm stumped on how to achieve a ranking output. I have my workbook currently set to calculate totals in one worksheet and then populate accordingly on a master sheet. But I would like to then rank those outputs and show the name of the team with the highest ranking score. For example, there are 10 teams in column A, their score populates automatically next to their name in column B. I'd like column B ranked with the highest score to the lowest and populate the cells in column F with the names of the teams only in order. I'm not sure if that makes sense or is possible.

Is it what you want

Book1
	A	B	C	D	E	F
1	Teams	Points			Place	Current Team Standings
2	A	3			10	J
3	B	4			9	I
4	C	1			8	H
5	D	2			7	G
6	E	5			6	F
7	F	6			5	E
8	G	7			4	B
9	H	8			3	A
10	I	9			2	D
11	J	10			1	C
12
13
Sheet1

Cell Formulas
Range	Formula
E2:E11	E2	=LARGE($B$2:$B$11,ROW()-1)
F2:F11	F2	=INDEX($A$2:$A$11,MATCH(E2,$B$2:$B$11,0))

 

[JamesCanale]

MrExcelPlayground2.xlsm
	P	Q	R	S	T
20	Team	Score		Top	Team
21	A	30		1	H
22	B	90		2	J
23	C	52		3	B
24	D	28		4	I
25	E	30		5	G
26	F	64		6	F
27	G	70		7	C
28	H	99		8	M
29	I	84		9	A
30	J	99		10	E
31	K	27
32	L	17
33	M	31
Sheet35

Cell Formulas
Range	Formula
T21:T30	T21	=INDEX(SORTBY($P$21:$P$33,$Q$21:$Q$33,-1),S21)

Good for ties.

 

[Fluff]

Hi & welcome to MrExcel.
Another option

=SORTBY(FILTER(A2:A24,B2:B24<>""),FILTER(B2:B24,B2:B24<>""),-1)

 

[kcross31]

Is it what you want

Book1
	A	B	C	D	E	F
1	Teams	Points			Place	Current Team Standings
2	A	3			10	J
3	B	4			9	I
4	C	1			8	H
5	D	2			7	G
6	E	5			6	F
7	F	6			5	E
8	G	7			4	B
9	H	8			3	A
10	I	9			2	D
11	J	10			1	C
12
13
Sheet1

Cell Formulas
Range	Formula
E2:E11	E2	=LARGE($B$2:$B$11,ROW()-1)
F2:F11	F2	=INDEX($A$2:$A$11,MATCH(E2,$B$2:$B$11,0))

Thank you so much! Super helpful! Lot's more to figure out so I may be posting some more! Thanks again!

 

[kcross31]

MrExcelPlayground2.xlsm
	P	Q	R	S	T
20	Team	Score		Top	Team
21	A	30		1	H
22	B	90		2	J
23	C	52		3	B
24	D	28		4	I
25	E	30		5	G
26	F	64		6	F
27	G	70		7	C
28	H	99		8	M
29	I	84		9	A
30	J	99		10	E
31	K	27
32	L	17
33	M	31
Sheet35

Cell Formulas
Range	Formula
T21:T30	T21	=INDEX(SORTBY($P$21:$P$33,$Q$21:$Q$33,-1),S21)

Good for ties.

Thank you so much! Super helpful! Lot's more to figure out so I may be posting some more! Thanks again!

 

[Sufiyan97]

Thank you so much! Super helpful! Lot's more to figure out so I may be posting some more! Thanks again!

Glad we could help and thanks for the feedback..

 

[kcross31]

MrExcelPlayground2.xlsm
	P	Q	R	S	T
20	Team	Score		Top	Team
21	A	30		1	H
22	B	90		2	J
23	C	52		3	B
24	D	28		4	I
25	E	30		5	G
26	F	64		6	F
27	G	70		7	C
28	H	99		8	M
29	I	84		9	A
30	J	99		10	E
31	K	27
32	L	17
33	M	31
Sheet35

Cell Formulas
Range	Formula
T21:T30	T21	=INDEX(SORTBY($P$21:$P$33,$Q$21:$Q$33,-1),S21)

Good for ties.

Thank you so much! Super helpful! Lot's more to figure out so I may be posting some more! Thanks again!

Hey there, I wanted to pose another question about ranking. This time for individual performers in the tournament. I'd like each weight class to be fluidly ranked as results are updated. I've attached images of the two sheet styles I am working with. Each team will have a sheet for them specifically. I'd like the workbook to search each of these sheets for each weight class, find the top 3 scorers ( points shown in Column I from the Team sheets) for each weight class (Column C) and then populate the ranking spots in the Team+Individual Scoring sheet with the wrestler's name and school (Columns I+J, K+L, M+N). I am unable to install the xl2bb add on because I have limited rights on my school computer or else I'd attach the whole workbook. Hopefully the images are good enough.

 

[Fluff]

As this is a totally different question, you need to start a new thread. Thanks