JoseAcosta
New member
- Local time
- Today, 13:40
- Joined
- Aug 2, 2018
- Messages
- 5
Hi,
This will be my first question.
I need to have in a excellent sheet 2 columns;
Column 1 will be continue numbers like;
1000
1001
1002
1003
etc....
Column 2 is the tricky one;
will be incremental like this:
001-0
001-2
001-3
001-4
etc...
but when it gets to 001-9 have to change to
002-1 and then....
002-2
002-3
002-4
until it reaches
999-9
column 1 will be increasing also but I have no problem is just make column 2 to increase and loop till it reaches 999-9
Thanks in advance for all your help
This will be my first question.
I need to have in a excellent sheet 2 columns;
Column 1 will be continue numbers like;
1000
1001
1002
1003
etc....
Column 2 is the tricky one;
will be incremental like this:
001-0
001-2
001-3
001-4
etc...
but when it gets to 001-9 have to change to
002-1 and then....
002-2
002-3
002-4
until it reaches
999-9
column 1 will be increasing also but I have no problem is just make column 2 to increase and loop till it reaches 999-9
Thanks in advance for all your help