Sjcorrea
New member
- Joined
- Feb 23, 2012
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Does anyone have any suggestions to do the following. I am trying to generate a unique reference number which repeats x number of times (in this example 3 times) before increasing.
BO-20-100-10001
BO-20-100-10001
BO-20-100-10001
BO-20-100-10002
BO-20-100-10002
BO-20-100-10002
BO-20-100-10003
BO-20-100-10003
BO-20-100-10003
and so forth.
I know how to create this list when each unique value is listed once. The trouble I am having is repeating the unique value x number of times and then increasing. Am I overlooking a very simple method for executing this type of series?
Regards
-Sam
BO-20-100-10001
BO-20-100-10001
BO-20-100-10001
BO-20-100-10002
BO-20-100-10002
BO-20-100-10002
BO-20-100-10003
BO-20-100-10003
BO-20-100-10003
and so forth.
I know how to create this list when each unique value is listed once. The trouble I am having is repeating the unique value x number of times and then increasing. Am I overlooking a very simple method for executing this type of series?
Regards
-Sam