Forum Discussion
Same No. - Different Prefix (A to ZZ)
Hi All, l'm wondering how can l setup the formula for the situation below: If column A appears more than one times, it will count from A to ZZ. If just only appears one time, then just shows ZZ. ...
Hi,
That could be
=IF(COUNTIF($A$1:$A$100,A1)-1,IF(INT((COUNTIF($A$1:$A1,A1)-1)/26)=0,"",CHAR(INT((COUNTIF($A$1:$A1,A1)-1)/26)+65))&CHAR(MOD(COUNTIF($A$1:$A1,A1)-1,26)+65),"ZZ")
Please see attached
Hello Sergei
My understanding is that the order would be A, B, C .... X, Y, Z, AA, AB, ...
Inspired by your solution I came up with a slightly different one.
See attached file.