at D2
=IFERROR(IF(ROW(1:1)>SUM($A$2:$A$5),"",IF(COUNTIF(D$1:D1,D1)=IFERROR(RANK(D1,$A$2:$A$5),0),1,D1+1)),1)
copy down