How can I Average a persons outcome or "rank" from several lists

[MattHam44]

Hello,

I am trying to figure out how I can take a given list of ranked outcomes and find the average outcome from the lists.

Say there are 5 runners who each raced 3 times and each race had a different outcome.
I want to find the average place of each runner to determine an average ranking.

Say Runner 1 gets 1st, 1st, and 2nd respectively.
Runner 2 gets 2nd, 4th, and 5th respectively.
Runner 3 gets 3rd, 5th and 1st.
Runner 4 gets 4th, 2nd and 4th.
Runner 5 gets 5th, 3rd and 3rd.

The list I would want should come out to:
R1, with Avg. 1.33
R3 with Avg. 3
R4 with 3.33
T- R2 and R5 with 3.67

	Race 1	Race 2	Race 3	AVG
1st Place	Runner 1	Runner 1	Runner 3	R1
2nd Place	R2	R4	R1	R3
3rd Place	R3	R5	R5	R4
4th Place	R4	R2	R4	R2
5th Place	R5	R3	R2	R5

I want to be able to do this with More than 5 runners and more than 3 races, that is just an example.
The "Runners" with be labeled by the their Names.

Wondering if there is a quicker way of doing this rather than going runner by runner and calculating their position.
Let me know if I can clarify anything else or if any additional information is needed.

Thanks

 

[GraH]

Something like this maybe seems rather simple?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Rank	Avrg.	Runner	Race 1	Race 2	Race 3	Race 4	Race 5	Race 6	Race 7	Race 8	Race 9	Race 10	Race 11	Race 12	Race 13	Race 14	Race 15	Race 16	Race 17	Race 18	Race 19	Race 20
2	2	4,45	Runner 1	10	1	1	6	8	1	3	2	6	6	9	8	2	1	9	6	3	1	3	3
3	1	4,15	Runner 2	2	4	5	3	6	5	1	1	7	8	2	4	1	6	7	7	5	2	1	6
4	5	5,25	Runner 3	6	2	8	2	5	8	5	10	3	1	8	9	10	3	5	3	2	6	5	4
5	4	4,8	Runner 4	1	6	6	7	2	6	4	4	10	3	7	1	4	4	2	10	9	5	4	1
6	8	6,15	Runner 5	9	9	2	8	1	2	6	5	9	9	6	5	5	5	4	9	8	8	6	7
7	7	5,85	Runner 6	3	3	4	9	9	4	7	3	8	4	4	7	3	9	10	8	6	7	7	2
8	9	6,8	Runner 7	7	7	9	10	10	9	8	7	5	2	3	6	7	7	8	5	4	4	8	10
9	10	7,2	Runner 8	8	5	7	1	3	7	10	9	4	5	10	10	9	8	6	4	10	9	10	9
10	6	5,7	Runner 9	4	10	10	5	4	10	2	8	1	7	5	2	8	10	3	1	7	10	2	5
11	3	4,65	Runner 10	5	8	3	4	7	3	9	6	2	10	1	3	6	2	1	2	1	3	9	8
Sheet1

Cell Formulas
Range	Formula
A2:A11	A2	=RANK.EQ(B2:B11,B2:B11,1)
B2:B11	B2	=AVERAGE(D2:W2)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J2:J11	Cell Value	duplicates	text	NO
I2:I11	Cell Value	duplicates	text	NO
L2:L11	Cell Value	duplicates	text	NO
K3:K11	Cell Value	duplicates	text	NO
W2:W11	Cell Value	duplicates	text	NO
V2:V11	Cell Value	duplicates	text	NO
U2:U11	Cell Value	duplicates	text	NO
T2:T11	Cell Value	duplicates	text	NO
S2:S11	Cell Value	duplicates	text	NO
R2:R11	Cell Value	duplicates	text	NO
Q2:Q11	Cell Value	duplicates	text	NO
P3:P12	Cell Value	duplicates	text	NO
O2:O11	Cell Value	duplicates	text	NO
N2:N11	Cell Value	duplicates	text	NO
M2:M11	Cell Value	duplicates	text	NO
H2:H11	Cell Value	duplicates	text	NO
G2:G11	Cell Value	duplicates	text	NO
F2:F11	Cell Value	duplicates	text	NO

 

[MattHam44]

Something like this maybe seems rather simple?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Rank	Avrg.	Runner	Race 1	Race 2	Race 3	Race 4	Race 5	Race 6	Race 7	Race 8	Race 9	Race 10	Race 11	Race 12	Race 13	Race 14	Race 15	Race 16	Race 17	Race 18	Race 19	Race 20
2	2	4,45	Runner 1	10	1	1	6	8	1	3	2	6	6	9	8	2	1	9	6	3	1	3	3
3	1	4,15	Runner 2	2	4	5	3	6	5	1	1	7	8	2	4	1	6	7	7	5	2	1	6
4	5	5,25	Runner 3	6	2	8	2	5	8	5	10	3	1	8	9	10	3	5	3	2	6	5	4
5	4	4,8	Runner 4	1	6	6	7	2	6	4	4	10	3	7	1	4	4	2	10	9	5	4	1
6	8	6,15	Runner 5	9	9	2	8	1	2	6	5	9	9	6	5	5	5	4	9	8	8	6	7
7	7	5,85	Runner 6	3	3	4	9	9	4	7	3	8	4	4	7	3	9	10	8	6	7	7	2
8	9	6,8	Runner 7	7	7	9	10	10	9	8	7	5	2	3	6	7	7	8	5	4	4	8	10
9	10	7,2	Runner 8	8	5	7	1	3	7	10	9	4	5	10	10	9	8	6	4	10	9	10	9
10	6	5,7	Runner 9	4	10	10	5	4	10	2	8	1	7	5	2	8	10	3	1	7	10	2	5
11	3	4,65	Runner 10	5	8	3	4	7	3	9	6	2	10	1	3	6	2	1	2	1	3	9	8
Sheet1

Cell Formulas
Range	Formula
A2:A11	A2	=RANK.EQ(B2:B11,B2:B11,1)
B2:B11	B2	=AVERAGE(D2:W2)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J2:J11	Cell Value	duplicates	text	NO
I2:I11	Cell Value	duplicates	text	NO
L2:L11	Cell Value	duplicates	text	NO
K3:K11	Cell Value	duplicates	text	NO
W2:W11	Cell Value	duplicates	text	NO
V2:V11	Cell Value	duplicates	text	NO
U2:U11	Cell Value	duplicates	text	NO
T2:T11	Cell Value	duplicates	text	NO
S2:S11	Cell Value	duplicates	text	NO
R2:R11	Cell Value	duplicates	text	NO
Q2:Q11	Cell Value	duplicates	text	NO
P3:P12	Cell Value	duplicates	text	NO
O2:O11	Cell Value	duplicates	text	NO
N2:N11	Cell Value	duplicates	text	NO
M2:M11	Cell Value	duplicates	text	NO
H2:H11	Cell Value	duplicates	text	NO
G2:G11	Cell Value	duplicates	text	NO
F2:F11	Cell Value	duplicates	text	NO

This Helps, Thanks s much!
I was able to use this to get a good idea of what to do next.