Ranking a set of scores

[Skiffie]

Hi there, I was searching for basically the question raised in this thread: Ranking a medal tally

While I'm not looking at medals the premise is the same. Over a sailing season, we are looking for the boat that has the "most fastest times". If one boat has a clear number more than any other, it is the winner. If there are more than one, then you move to the ranking the second places ad so on until the tie is broken.

In the example, Avro, Truant III and Uncle Fred all have 3 x 1sts, so we move to the 2nd places. Avro and Uncle Fred have 2 x 2nds each, so need to be split by the third places. Avro has 3 x 3rds to Uncle Fred's 2, so Avro would be ranked first and Uncle Fred second, Truant III third. Merle would be 4th overall to Truant II in 5th due to the split happening at the 4th places. Then this leaves Wrecker in 6th.

H10s Race Results 2022-23.xlsx
	A	B	C	D	E	F	G	H	I	J	K
56	Most Fastest Times
57	Skiffs	1sts	2nds	3rds	4ths	5ths	6ths	DNF	DNS	DNC	Rank
58	Avro	3	2	3	1	1	0	2	0	0
59	Merle	1	4	2	3	1	1	0	0	0
60	Truant II	1	4	2	0	0	0	0	0	5
61	Truant III	3	0	0	2	2	0	5	0	0
62	Uncle Fred	3	2	2	5	0	0	0	0	0
63	Wrecker	1	0	1	1	2	3	1	0	3
Summary

It's one that's been a puzzle to me for some years!!

Thanks in advance for your consideration!

 

[Fluff]

Glad we could help & thanks for the feedback.

I like that it's not relying upon a multiplier like the others.

Actually it is, they all do.