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 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?
|