Number Suffixes

Originally Posted by MarvinP

Hi Guys,

Try this answer with a helper column and no need to convert to a text string.

Or numeric without a helper

Formula:

=IF(A1="","",A1*10^2+COUNTIF(A$1:A1,A1))