Return value for 1st, 2nd, 3rd, 4th occurance

[Bany26]

Dear all,

could you please help me return different notes for old and new entries considering the date (column A)? I would need for newest row insert note ''valid'' in column C. And for rest - older rows, I would need note ''old'' in column C.

Date	Name	result
20.9.2016	Kevin	old
7.2.2017	Kevin	old
8.5.2017	Kevin	old
10.4.2018	Kevin	valid
22.3.2018	Alexander	old
10.4.2018	Alexander	valid
10.4.2018	Mike	valid

<colgroup><col><col><col></colgroup><tbody>
</tbody>

thank you in advance

 

[AlanY]

this works if column A is true dates, (e.g. replace the . with - or /);

Excel 2013/2016
	A	B	C
1	Date	Name	result
2	20/09/2016	Kevin	old
3	07/02/2017	Kevin	old
4	08/05/2017	Kevin	old
5	10/04/2018	Kevin	valid
6	22/03/2018	Alexander	old
7	10/04/2018	Alexander	valid
8	10/04/2018	Mike	valid
Sheet2

Cell Formulas
Range	Formula
C2	{=IF(MAX(IF($B$2:$B$8=B2,$A$2:$A$8))=A2,"valid","old")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Bany26]

AlanY this is excellent. Thank you so much

 

[AlanY]

you're welcome