Assigning additional Letters for duplicate numbers

[mactrading]

Hi,

Is it possible when I paste a sequence of numbers in B and when there are duplicates it will assign a letter at the end of the number and the letters that can be added will depend on how many the duplicates are?

[Bo_Ry]

Please try at
C2
=B2&IF(COUNTIFS($B$2:$B$17,B2)>1,CHAR(96+COUNTIFS(B$2:B2,B2)),"")
drag down

or
D2 Spill array
=LET(z,B2:B17,r,ROW(z),z&IF(ISERROR(MATCH(z,UNIQUE(z,,1),)),CHAR(MMULT((z=TRANSPOSE(z))*(r>=TRANSPOSE(r)),r^0)+96),""))

[mactrading]

Hi,

Thank you so so so so much You solved my problem.


Yehey!!!!