| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add identifiers to a list of numbers
I am looking for some help¦I am trying to find a way to make duplicates and
add identifiers to a list of numbers. I can generate the sequential numbers no problem (easy I know) but I am having trouble finding a way to get the list repeat each number say twice and add a -1 to the first one and a -2 to the second. For example: I can get: 1111 1112 1113 But I cant figure out how to get 1111 1111-1 1111 1111-2 1112 OR 1112-1 1112 1112-2 1113 1113-1 1113 1113-2 Can some one point me in the right direction? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| two columns range of numbers need to list all numbers in the range | New Users to Excel | |||
| Display the last non-zero value in a list of numbers | Excel Discussion (Misc queries) | |||
| Adding numbers from a list over a specific value | Excel Discussion (Misc queries) | |||
| how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) | |||
| find sum in list of of numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
