| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i insert numbers from Random list (1-60) without repeating | Excel Discussion (Misc queries) | |||
| how do i insert numbers from Random list (1-45) without repeating | Excel Discussion (Misc queries) | |||
| How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
| How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
| Random list (1-45) without repeating numbers? | Excel Worksheet Functions | |||
Hybrid Mode
