SMALL/LARGE Command

[JTL9161]

I am working on a golf league spreadsheet. I am using the following formula to sort the members by net score.

=SUMPRODUCT((ABS(Z3-0)>ABS($Z$3:$Z$22-0))+0)+1

The problem is that in golf a negative score should put a golfer ahead of golfer with a "0" or Even score and ahead of a golfer with a plus score.

Current List
ABC +2
DEF 0
GHI +1
XYZ -1

What I need after sorting
XYZ -1
DEF 0
GHI +1
ABC +2

Thanks
James

 

[Fluff]

Nope, that's just a single cell. You need to select the whole range.

 

[JTL9161]

Test1.xlsx
	A	B	C	D	E	F	G	H
1
2				Net Tot	Hole Grs.	Hole Net
3		1	Bryan	0
4		3	Chris	-1
5		1	Dave	0
6		4	Pete	-2
7		4	Don	+2
8		6	Jim	+3
9
10
11
12		What I need
13		3	Bryan	0
14		2	Chris	-1
15		3	Dave	0
16		1	Pete	-2
17		5	Don	+2
18		6	Jim	+3
19
20
21
22
23
24
25
26
Sheet1

Cell Formulas
Range	Formula
D3	D3	=Sheet2!V6
D4	D4	=Sheet2!V9
D5	D5	=Sheet2!V12
B3:B8,B18	B3	=SUMPRODUCT((ABS(D3-0)>ABS($D$3:$D$8-0))+0)+1

 

[Fluff]

Thanks for that.
Why not use

=RANK.EQ(D13,$D$13:$D$18,1)

 

[JTL9161]

What cell am I putting that in?

 

[JTL9161]

Nevermind. I forgot the $

thanks for your help

 

[Fluff]

B3 or B13 & drag down.