Hi,

Am Thu, 8 Sep 2016 09:18:22 -0700 (PDT) schrieb GoTeamGo4321:

I have a list of values listed below (actual list is hundreds of thousands of lines) that I need to read as 1, 1a, 1b, 1c, 1d, 1e, 2, 2a, 2b, etc..... Is there a way to do this formulaically? I'm racking my brain on this one....

try in a helper column
=A1&CHOOSE(COUNTIF($A$1:A1,A1),"","a","b","c","d", "e","f")
or
=IF(COUNTIF($A$1:A1,A1)=1,A1,A1&CHAR(COUNTIF($A$1: A1,A1)+95))


Regards
Claus B.
--
Windows10
Office 2016