Score sheet with class rankings

[NoelD]

Hello,
I have a score sheet for a motorsport autotest and I can rank the overall scores, however I want to rank the sub-class scores relative to the class as per the attached extract from the spreadsheet and I cant make the formula work...any help would be appreciated

Number	Name	Car	Class	Total	Finish Ranking	CLASS 1	CLASS 2	CLASS 3	CLASS 4	CLASS 5
1	Piers MacFaeorais	MX5	1	1310.34	1	1
2	Philip O'Reilly	Starlet	3	1348.86	3
3	Christopher Evans	MR2	5	1451.05	6
4	Noel Devlin	MX5	4	1373.14	5
5	Mick Kehoe	Peugeot 206	3	1315.09	2
6	Martin Devine	MX5	4	1551.94	8
7	Bernard Bradley	MX5	4	1501.06	7
8	Richie O'Mahoney	Corsa	2	1579.89	10
9	Matthew Devlin	Corsa	2	1613.78	11
10	Mark Reilly	Starlet	2	1619.95	12
11	Darragh Gibbons	Starlet	2	1573.63	9
12	John Carroll	MR2	5	1370.78	4

 

[Asbestos_Jen]

Try this:

Book3
	A	B	C	D	E	F	G	H	I	J	K
5						Finish
6	Number	Name	Car	Class	Total	Ranking	CLASS 1	CLASS 2	CLASS 3	CLASS 4	CLASS 5
7	1	Piers MacFaeorais	MX5	1	1310.34	1	1
8	2	Philip O'Reilly	Starlet	3	1348.86	3			1
9	3	Christopher Evans	MR2	5	1451.05	6					1
10	4	Noel Devlin	MX5	4	1373.14	5				3
11	5	Mick Kehoe	Peugeot 206	3	1315.09	2			2
12	6	Martin Devine	MX5	4	1551.94	8				1
13	7	Bernard Bradley	MX5	4	1501.06	7				2
14	8	Richie O'Mahoney	Corsa	2	1579.89	10		3
15	9	Matthew Devlin	Corsa	2	1613.78	11		2
16	10	Mark Reilly	Starlet	2	1619.95	12		1
17	11	Darragh Gibbons	Starlet	2	1573.63	9		4
18	12	John Carroll	MR2	5	1370.78	4					2
Group ranking

Cell Formulas
Range	Formula
F7:F18	F7	=RANK(E7,$E$7:$E$18,1)
G7:K18	G7	=IF($D$6&" "&$D7=G$6,SUMPRODUCT(($D7=$D$7:$D$18)*($E7<$E$7:$E$18))+1,"")
Press CTRL+SHIFT+ENTER to enter array formulas.

Modified from this page: How to Rank within Groups in Excel

 

[Eric W]

Try:

Book2
	A	B	C	D	E	F	G	H	I	J	K
1	Number	Name	Car	Class	Total	Ranking	Class 1	Class 2	Class 3	Class 4	Class 5
2	1	Piers MacFaeorais	MX5	1	1310.34	1	1
3	2	Philip O'Reilly	Starlet	3	1348.86	3			1
4	3	Christopher Evans	MR2	5	1451.05	6					1
5	4	Noel Devlin	MX5	4	1373.14	5				3
6	5	Mick Kehoe	Peugeot 206	3	1315.09	2			2
7	6	Martin Devine	MX5	4	1551.94	8				1
8	7	Bernard Bradley	MX5	4	1501.06	7				2
9	8	Richie O'Mahoney	Corsa	2	1579.89	10		3
10	9	Matthew Devlin	Corsa	2	1613.78	11		2
11	10	Mark Reilly	Starlet	2	1619.95	12		1
12	11	Darragh Gibbons	Starlet	2	1573.63	9		4
13	12	John Carroll	MR2	5	1370.78	4					2
Sheet3

Cell Formulas
Range	Formula
G2:K13	G2	=IF($D2&""=RIGHT(G$1),COUNTIFS($D$2:$D$13,$D2,$E$2:$E$13,">="&$E2),"")

 

[NoelD]

Thank you for the solutions...