Excel Non VBA solution to Determine Winners - Low Gross/Low Net

[Richard2542]

 

[Richard2542]

Stephen...this looks like a brilliant solution, however, I have copied you post #40 and validated that the formulae agree with above - all I get is a 0 (zero) value in the rank fields. I recreated your exact sheet, including columns and rows - no luck (as well, I used the Named Range "N"); my 2nd thought was that the formula was an array...same result (0's). I must be missing something and just can't find my error.

 

[StephenCrump]

Attached is your workbook from Post #30 with the changes highlighted below: V2

I dummied the data to include lots of ties, and it seems to work as required.

Tournament Worksheet - Fix Ties - V2.xlsx
	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN
74	Player Rank - Round 2 - Ties B Flight
75	1		2		3		4		5
76	Gross	Net	Gross	Net	Gross	Net	Gross	Net	Gross	Net
77
78										5
79
80					3
81									5
82								4
83	1
84
85		1
86
87				2
88			2
89
90
91						3
92							4
93
94
95
League Tournament

Tournament Worksheet - Fix Ties - V2.xlsx
	DL	DM	DN	DO	DP	DQ	DR	DS
75	MyCount	46
76	RANK	FINAL	....	14	15	16	17	18
77	PLAYER 4	22		22	22	22	21	16
78	PLAYER 5	20		20	20	20	20	16
79	PLAYER 6
80	PLAYER 24	1		1	1	1	1	1
81	PLAYER 66	16		16	16	16	16	16
82	PLAYER 68	17		17	17	17	16	16
83	PLAYER 78	9		9	9	9	9	8
84	PLAYER 80	7		7	7	7	7	1
85	PLAYER 94	5		5	5	5	5	1
86	PLAYER 95	24		24	24	24	24	24
87	PLAYER 99	25		25	25	25	25	24
88	PLAYER 105	4		4	4	2	2	1
89	PLAYER 114	13		13	13	12	11	8
90	PLAYER 124	6		6	6	6	5	1
91	PLAYER 125	11		11	11	11	11	8
92	PLAYER 141	2		2	2	2	2	1
93	PLAYER 147	14		14	14	14	14	8
94	PLAYER 156	23		23	23	22	21	16
95	PLAYER 157	8		8	8	8	8	8
96	PLAYER 158	3		3	3	2	2	1
97	PLAYER 177	21		21	21	21	21	16
98	PLAYER 186	19		19	19	19	19	16
99	PLAYER 187	10		10	10	10	10	8
100	PLAYER 194	12		12	12	12	11	8
101	PLAYER 201	18		18	18	17	16	16
102	PLAYER 209	15		15	15	14	14	8
League Tournament

 

[Richard2542]

Stephen...Outstanding job, I couldn't be happier - a truly brilliant solution. I figured out why I was having difficulties...fyi, I am using Office Pro 2013...the "Tie Break" formulae in Post #42 are Arrays and I was using a straight formula ("DUHHHHH..." on my part).
You have been so patient and professional in helping me through this...I just can't thank you enough.

Richard

 

[StephenCrump]

I am using Office Pro 2013...the "Tie Break" formulae in Post #42 are Arrays and I was using a straight formula ("DUHHHHH..." on my part).

Partly my fault. I'm enjoying Excel 365, with arrays spilling and scalars evaluating as you'd reasonably expect, and happily forgetting whether or not I'd previously have to array-enter.

I'm glad your formulae are all working. Happy golfing!