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.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
thank you in advance
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