Apr 13 2019 02:25 AM
@ClauP , unfortunately your file is not downloadable
Apr 13 2019 02:37 AM
Hi @ClauP,
I suggest this formula:
=IF(COUNTIF($A$2:$A$8,A2)>1,A2&"A"&COUNTIF($A$2:A2,A2),A2)
Please find it in the attached file as well.
Regards,
Haytham