04-13-2019 12:29 AM
Hello
Can a expert help with this?
BR/ClauP
04-13-2019 02:25 AM
@ClauP , unfortunately your file is not downloadable
04-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