Ranking if condition is met

[simplyskid]

Hello everyone,

Statistics do not lie, and i'm working on a spreadsheet to pull individual information based on how I perform each week. Can someone give me a little guidance as to how I would be able to RANK the times based on which Kart I was driving? ive attached a little bit of the workbook, but im up to 200 races now. (currently using the table function in order to perform manually)

[TABLE="width: 320"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"]A[/TD]
[TD="width: 64"]B[/TD]
[TD="width: 64"]C[/TD]
[TD="width: 64"]D[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="class: xl65"]Race #[/TD]
[TD="class: xl65"]date[/TD]
[TD="class: xl65"]kart #[/TD]
[TD="class: xl65"]Fast time[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="class: xl66, align: right"]1[/TD]
[TD="class: xl67, align: right"]7/2/2017[/TD]
[TD="class: xl66, align: right"]1[/TD]
[TD="class: xl66, align: right"]21.929[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="class: xl68, align: right"]7/2/2017[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]21.517[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="class: xl66, align: right"]3[/TD]
[TD="class: xl67, align: right"]7/2/2017[/TD]
[TD="class: xl66, align: right"]3[/TD]
[TD="class: xl66, align: right"]21.014[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="class: xl68, align: right"]7/2/2017[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]21.337[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="class: xl66, align: right"]5[/TD]
[TD="class: xl67, align: right"]7/2/2017[/TD]
[TD="class: xl66, align: right"]6[/TD]
[TD="class: xl66, align: right"]21.216[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="class: xl68, align: right"]7/9/2017[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]20.994[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="class: xl66, align: right"]7[/TD]
[TD="class: xl67, align: right"]7/9/2017[/TD]
[TD="class: xl66, align: right"]4[/TD]
[TD="class: xl66, align: right"]20.757[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]8[/TD]
[TD="class: xl68, align: right"]7/9/2017[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]21.54[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Welcome to the MrExcel board!

Like this?

Excel Workbook
	C	D	E
1	kart #	Fast time	Rank by kart
2	1	21.929	2
3	6	21.517	2
4	3	21.014	1
5	1	21.337	1
6	6	21.216	1
7	2	20.994	1
8	4	20.757	1
9	22	21.54	1
Rank