I am trying to create two columns.
The first column will have integers from 1 to 2000 and each integer repeats 6 times, so the first column entries would be 1,1,1,1,1,1, 2,2,2,2,2,2 etc up to 2000.
The second column needs to have the numbers: 1, 2,3,4,5,6 repeating over and over.
So it would look as follows:
1 1
1 2
1 3
1 4
1 5
1 6
2 1
2 2
2 3
2 4
2 5
2 6
and so forth. Is there an easy way to do this?
IN A1, copied down:
=INT((ROWS($A$1:A1)-1)/6)+1
In B1, copied down:
=MOD((ROWS($B$1:B1)-1),6)+1
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
A1b1
Please Login or Register to view this content.try this and copy towards downPlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi Siva, You must be a bit sleepy today!! I beat you to it!!
Hi Glen, this worked perfectly.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks