Multi-condition sorting issue

[Oldsquid]

I would like to do, for lack of better description, a double sort on two set of numbers, based on a 3rd (variable) number.
Score 41 45 52 45 38 52 47 35 42 34
Names Adam Danille Davy Dori Bill Mom Randy Angi Shane
# Wins 11 10 10 9 10 10 10 11 9

I would like it to sort by number of wins, then, closest, but not over the score, then over the score. Then, go to the next highest number of wins and do the same thing again. To show 1st, 2nd and 3rd place.

To look like this:

Angi Adam Randy
11 11 10
1 2 3

 

[AhoyNC]

Try:

Book1
	A	B	C	D	E	F	G	H
1	Score	41		Check for
2	Score	Names	Wins	Closest		Names	Wins	Closest
3	45	Adam	11	4		Angi	11	1
4	52	Danille	10	11		Adam	11	4
5	45	Davy	10	4		Randy	10	-6
6	38	Dori	9	-3
7	52	Bill	10	11
8	47	Mom	10	6
9	35	Randy	10	-6
10	42	Angi	11	1
11	34	Shane	9	-7
Sheet3

Cell Formulas
Range	Formula
F3:H5	F3	=TAKE(SORTBY($B$3:$D$11,$C$3:$C$11,-1,$A$3:$A$11-$B$1,1),3)
D3:D11	D3	=A3-$B$1
Dynamic array formulas.

 

[Oldsquid]

I copied this to my sheet, I'm getting an error: " A value used in the formula is of the wrong data type."

Could you advise what I'm missing?

17.xlsx

Microsoft Excel Workbook

1drv.ms

I have tried to install XL2BB, but 365 doesn't allow it to run.

 

[AhoyNC]

Try this:
Note I changed the way you calculated the difference. I subtracted their score from the actual score based on your quote of "then, closest, but not over the score, then over the score".

Book1
	K	L	M	N	O	P	Q	R	S	T	U	V
34
35	41			45	52	45	38	52	47	35	42	34
36
37			Names	Adam	Danille	Davy	Dori	Bill	Pimp Nana	Randy	Angi	Shane
38			# Wins	11	10	10	9	10	10	10	11	9
39			Difference	4	11	4	-3	11	6	-6	1	-7
40
41			Names	Angi	Adam	Randy
42			# Wins	11	11	10
43			Difference	1	4	-6
Sheet1

Cell Formulas
Range	Formula
N39:V39	N39	=N35-$K$35
N41:P43	N41	=TAKE(SORTBY($N$37:$V$39,$N$38:$V$38,-1,N39:V39,1),,3)
Dynamic array formulas.

 

[Oldsquid]

Thank you so much!!!
I had never seen the function Take() before; I'll have to look into it to expand my function knowledge.

 

[AhoyNC]

You're welcome thanks for the feedback. I noticed it looked like you had some merged cells in your worksheet. It is usually best to avoid merged cells as they can cause problems with formulas that try to use a merged cell.
Also, below is a link on the take function. It starts at the 3:44 mark in the video.