A5: 1
A6: =IF(COUNTIF(C$5:C5,C6),INDEX(A$5:A5,MATCH(C6,C$5:C5,0)),MAX(A$5:A5)+1)

Copy down to A20