Rank players by different criteria

[svsyy]

Hi all,
I am trying to create an excel data table that ranks players for each criteria on its own (points, rebounds, steals, assists, and so forth).
Sample data for simplicity sake.
table 1:
players points rebounds steals assists
playera 15 3 2 1
playerb 12 5 5 3
playerc 7 10 5 1

desired output in 2 tables
tableoutput.1
points rebounds steals assists
15 10 5 3
12 5 5 1
7 3 2 1

tableoutput.2
points, rebounds, steals assists
playera playerc playerb playerb
playerb playerb playerc playera
playerc playera playera playerc

I can create the first desired data table using sort descending function.
I am getting stuck with the second desired data table. I tried using index match however repeat values give the first result that matches rather than the next one. So for steals, playerb comes out twice instead of playerb then playerc (similar for assists with playera coming out twice instead of playera and then playerc).

I can create player columns after each category and then sort descending, however I have a lot more criteria ie columns that I would need to sort so manually creating columns and then sorting for each criteria becomes very time consuming. Hoping for a more efficient solution.

Thanks in advance for your help!!!

 

[svsyy]

Logically player b still comes last for steals but if you want empty cells to be treated as not applicable then you can just use an IF statement:

Svsyy.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Table1						Tableoutput1					Tableoutput2
2	players	points	rebounds	steals	assists		points	rebounds	steals	assists		points	rebounds	steals	assists
3	a	15	3	2	1		15	10	5	3		a	c	c	b
4	b	12	5		3		12	5	2	1		b	b	a	a
5	c	7	10	5	1		7	3		1		c	a		c
Sheet1 (2)

Cell Formulas
Range	Formula
G3:J5	G3	=IFERROR(AGGREGATE(14,6,B$3:B$5,ROW()-ROW($G$2)),"")
L3:O5	L3	=IF(G3="","",INDEX($A$3:$A$5,AGGREGATE(15,6,ROW($A$3:$A$5)-ROW($A$2)/(B$3:B$5=G3),COUNTIF(G$2:G3,G3))))

perfect. i wanted the flexibility to either have it with the name or not. now i can show names for those that hit certain criteria only.
thanks!

 

[svsyy]

Logically player b still comes last for steals but if you want empty cells to be treated as not applicable then you can just use an IF statement:

Svsyy.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Table1						Tableoutput1					Tableoutput2
2	players	points	rebounds	steals	assists		points	rebounds	steals	assists		points	rebounds	steals	assists
3	a	15	3	2	1		15	10	5	3		a	c	c	b
4	b	12	5		3		12	5	2	1		b	b	a	a
5	c	7	10	5	1		7	3		1		c	a		c
Sheet1 (2)

Cell Formulas
Range	Formula
G3:J5	G3	=IFERROR(AGGREGATE(14,6,B$3:B$5,ROW()-ROW($G$2)),"")
L3:O5	L3	=IF(G3="","",INDEX($A$3:$A$5,AGGREGATE(15,6,ROW($A$3:$A$5)-ROW($A$2)/(B$3:B$5=G3),COUNTIF(G$2:G3,G3))))

sorry reposted. thought my other message didn't get posted since i couldn't see it. tried to delete this reposted message but i couldn't delete ?

 

[C Moore]

Maybe it off by a column. Instead of 1 2 3 4 try 2 3 4 5 or Columns($B:B)+1