List of multiple repeating numbers assigned unique but like valueswith a formula
 

Hi,

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....

Number Vals
1
1
1
1
1
2
2
2
2
2
3
3
3
3
3
4
4
4
4
5
5
5
5
5
6
6
6
6
7
7
7
7
7

List of multiple repeating numbers assigned unique but like values with a formula
 

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

List of multiple repeating numbers assigned unique but likevalues with a formula
 

On Thursday, September 8, 2016 at 1:18:22 PM UTC-4, Claus Busch wrote:
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


Claus - The second function you provided was exactly what I needed! Thank you so much!!!

List of multiple repeating numbers assigned unique but likevalues with a formula
 

On Thursday, September 8, 2016 at 12:18:44 PM UTC-4, GoTeamGo4321 wrote:
Hi,

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....

Number Vals
1
1
1
1
1
2
2
2
2
2
3
3
3
3
3
4
4
4
4
5
5
5
5
5
6
6
6
6
7
7
7
7
7