How to restart this letter incrementation based on a condition using Google Sheets Formula?

Viewed 18
1 Answers

use:

=INDEX(IF(A3:A="",,A3:A&"-"&CHAR(COUNTIFS(A3:A, A3:A, ROW(A3:A), "<="&ROW(A3:A))+64)))

enter image description here

Related