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.

Car	Date	Rank
Volvo	01/01/2018	2
volvo	04/02/2018	1
audi	04/03/2018	1
bmw	20/02/2018	1

<tbody>
</tbody>

 

[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)