| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add identifiers to a list of numbers
I am looking for some helpI 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add identifiers to a list of numbers
In a column to the right of your 1111, 1111, 1112, 1112, 1113, 1113 column I
put this formula: =A1&"-1" and in the next cell down I put this formula =A2&"-2" This created 1111-1 and then 1111-2. I then highlighted those two formulas and copied them down and it gave me 1112-1, 1112-2, 1113-1, 1113-2 Is that what you wanted? "Mike" wrote: I am looking for some helpI 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add identifiers to a list of numbers
Thank you for responding
I was actually trying to get excel to automate the process so that I could tell excel I want 2 of each number and it will duplicate the numbers and add the -1 and -2. I can get the input boxes and stuff like that but I am not sure how to get excel to make 2 of each number and label themdoes that make sense? "tim m" wrote: In a column to the right of your 1111, 1111, 1112, 1112, 1113, 1113 column I put this formula: =A1&"-1" and in the next cell down I put this formula =A2&"-2" This created 1111-1 and then 1111-2. I then highlighted those two formulas and copied them down and it gave me 1112-1, 1112-2, 1113-1, 1113-2 Is that what you wanted? "Mike" wrote: I am looking for some helpI 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add identifiers to a list of numbers
You would need to create a macro for that I believe. I'd post this question
on the programming forum and I bet you'll get someone to create a small macro for you that way. "Mike" wrote: Thank you for responding I was actually trying to get excel to automate the process so that I could tell excel I want 2 of each number and it will duplicate the numbers and add the -1 and -2. I can get the input boxes and stuff like that but I am not sure how to get excel to make 2 of each number and label themdoes that make sense? "tim m" wrote: In a column to the right of your 1111, 1111, 1112, 1112, 1113, 1113 column I put this formula: =A1&"-1" and in the next cell down I put this formula =A2&"-2" This created 1111-1 and then 1111-2. I then highlighted those two formulas and copied them down and it gave me 1112-1, 1112-2, 1113-1, 1113-2 Is that what you wanted? "Mike" wrote: I am looking for some helpI 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add identifiers to a list of numbers
Thanks I'll give that a try!
"tim m" wrote: You would need to create a macro for that I believe. I'd post this question on the programming forum and I bet you'll get someone to create a small macro for you that way. "Mike" wrote: Thank you for responding I was actually trying to get excel to automate the process so that I could tell excel I want 2 of each number and it will duplicate the numbers and add the -1 and -2. I can get the input boxes and stuff like that but I am not sure how to get excel to make 2 of each number and label themdoes that make sense? "tim m" wrote: In a column to the right of your 1111, 1111, 1112, 1112, 1113, 1113 column I put this formula: =A1&"-1" and in the next cell down I put this formula =A2&"-2" This created 1111-1 and then 1111-2. I then highlighted those two formulas and copied them down and it gave me 1112-1, 1112-2, 1113-1, 1113-2 Is that what you wanted? "Mike" wrote: I am looking for some helpI 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add identifiers to a list of numbers
Mike
Tim gave you part and I will see if I can give you the other part. A B C 1 1111 2 1111 3 =A1+1 4 =A2 Select A3 and A4, then drag down as far as you need. Does this Help you? Mike Rogers "Mike" wrote: I am looking for some helpI 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? |
| Reply |
| 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) | |||
Hybrid Mode
