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.



[TABLE="width: 245"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]result[/TD]
[/TR]
[TR]
[TD]20.9.2016[/TD]
[TD]Kevin[/TD]
[TD]old[/TD]
[/TR]
[TR]
[TD]7.2.2017[/TD]
[TD]Kevin[/TD]
[TD]old[/TD]
[/TR]
[TR]
[TD]8.5.2017[/TD]
[TD]Kevin[/TD]
[TD]old[/TD]
[/TR]
[TR]
[TD]10.4.2018[/TD]
[TD]Kevin[/TD]
[TD]valid[/TD]
[/TR]
[TR]
[TD]22.3.2018[/TD]
[TD]Alexander[/TD]
[TD]old[/TD]
[/TR]
[TR]
[TD]10.4.2018[/TD]
[TD]Alexander[/TD]
[TD]valid[/TD]
[/TR]
[TR]
[TD]10.4.2018[/TD]
[TD]Mike[/TD]
[TD]valid
[/TD]
[/TR]
</tbody>[/TABLE]


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