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

Giganews Newsgroups
Subject: List of multiple repeating numbers assigned unique but like values with a formula
Posted by:  GoTeamGo4321 (evansit…@gmail.com)
Date: Thu, 8 Sep 2016

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

Replies