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
|