Issues Sorting based on multiple columns (using SUMPRODUCT)

[johnrlalor]

Hi,
I have a spreadsheet for calculating golf positions after 4 rounds using the 4th, then 3rd, 2nd etc as the tie breaker. The ranking is working fine for Days 1 & 2 however when I try to rank for days 3 & 4 I can't get the functionality working.
Formulas I am using are below, any help appreciated
Day 1 & 2 rank below - Cell E2 =RANK(D2,$D$2:$D$13)+SUMPRODUCT(--($D$2:$D$13=$D2),--(C2<$C$2:$C$13))
Day 1 to 3 rank - Cell H2 =RANK(G2,$G$2:$G$13)+SUMPRODUCT(--($G$2:$G$13=$G2),--(F2<$F$2:$F$13),--(C2<$C$2:$C$13))
Overall rank - Cell K2 =RANK(J2,$J$2:$J$13)+SUMPRODUCT(--($J$2:$J$13=$J2),--(I2<$I$2:$I$13),--(F2<$F$2:$F$13),--(C2<$C$2:$C$13))

Name	Course 1	Course 2	Day 1 + 2 pts	Day 1 & 2 Rank	Course 3	Day 1 to 3 Points	Day 1 to 3 Rank	Course 4	Overall Best 3 out of 4	Overall Rank
Player 1	31	24	55	7	30	85	6	33	94	1
Player 2	34	27	61	3	29	90	1	26	90	9
Player 3	36	20	56	6	25	81	10	30	91	6
Player 4	25	28	53	9	32	85	5	30	90	8
Player 5	25	21	46	12	26	72	12	35	86	11
Player 6	36	29	65	1	25	90	1	27	92	3
Player 7	30	23	53	10	33	86	4	31	94	1
Player 8	31	27	58	4	26	84	9	26	84	12
Player 9	24	30	54	8	24	78	11	37	91	6
Player 10	31	26	57	5	28	85	6	33	92	3
Player 11	35	18	53	11	32	85	5	25	92	3
Player 12	32	30	62	2	27	89	3	26	89	10

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Name	Course 1	Course 2	Day 1 + 2 pts	Day 1 & 2 Rank	Course 3	Day 1 to 3 Points	Day 1 to 3 Rank	Course 4	Overall Best 3 out of 3		Overall Rank
2	Player 1	31	24	55	7	30	85	6	33	94	333024	1
3	Player 2	34	27	61	3	29	90	1	26	90	262927	9
4	Player 3	36	20	56	6	25	81	10	30	91	302520	7
5	Player 4	25	28	53	9	32	85	5	30	90	303228	8
6	Player 5	25	21	46	12	26	72	12	35	86	352621	11
7	Player 6	36	29	65	1	25	90	1	27	92	272529	4
8	Player 7	30	23	53	10	33	86	4	31	94	313323	2
9	Player 8	31	27	58	4	26	84	9	26	84	262627	12
10	Player 9	24	30	54	8	24	78	11	37	91	372430	6
11	Player 10	31	26	57	5	28	85	6	33	92	332826	3
12	Player 11	35	18	53	11	32	85	5	25	92	253218	5
13	Player 12	32	30	62	2	27	89	3	26	89	262730	10
Clubs

Cell Formulas
Range	Formula
K2:K13	K2	=VALUE(I2&F2&C2)
L2:L13	L2	=RANK(J2,$J$2:$J$13)+SUMPRODUCT(--($J$2:$J$13=$J2),--(K2<$K$2:$K$13))

 

[johnrlalor]

That will do nicely, thanks for simplifying it for me.

 

[Fluff]

You're welcome & thanks for the feedback.