[Solved] Repeating series of numbers-unique id needed January 25, 2023 by Kirat Doable with formulas and and helper column: In column E (Helper): =IF(A2=A1,"",A2) In Column C (Output): =IF(E2="",C1,CHAR(COUNTIF($E$2:E2,E2)+64)) 0 solved Repeating series of numbers-unique id needed