View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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?