VBA? dates rank? possible?

[rsj88]

Need a Vba code to obtain the rank for the latest date and car type.

EG find the latest date from today() for each car then obtain a rank. if the car changes the rank starts from 1 again. so In theory the latest 25 dates for each car.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Car[/TD]
[TD]Date[/TD]
[TD]Rank[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Volvo[/TD]
[TD]01/01/2018[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]volvo[/TD]
[TD]04/02/2018[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]audi[/TD]
[TD]04/03/2018[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bmw[/TD]
[TD]20/02/2018[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

so In theory the latest 25 dates for each car.

Hi, not sure what that means - but maybe you could try this.

Excel 2013/2016
	A	B	C
1	Car	Date	Rank
2	Volvo	01/01/2018	2
3	volvo	04/02/2018	1
4	audi	04/03/2018	1
5	bmw	20/02/2018	1
Sheet1

Cell Formulas
Range	Formula
C2	=1+COUNTIFS($A$2:$A$5,A2,$B$2:$B$5,">"&B2)