Alternate formula for CHAR formua in excle

[aravindhan_31]

I have Dates like this in col A and I have entered the formula
=CHAR(COUNTIF($A$1:$A1,A1)+48 in Column B it gives the below result.

Please Login or Register  to view this content.

But after 9 it startes giveing symbols instead of sequential numbers. is there a alternative way to give sequential numbers for all duplicate entires ?

[Bob Phillips]

Just use

=COUNTIF($A$1:$A1,A1)