Boston Brandon
New Member
- Joined
- Mar 27, 2024
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
I have 1100 sequential numbers that need to be in a certain order which I can't explain lol.
See image. Notice the pattern. the number "1" in cell one. The number "2" in cell 15. The number "3" in cell 29. (every 14th cell)
Number "17" in cell 2. Number "18" in cell 16, number "19" in cell 30 (every 16th number)
They will all be down column A till the number 1100. (I have them in C and E to be able to see the pattern)
Is there a fill series or table or something that would be able to do this?
See image. Notice the pattern. the number "1" in cell one. The number "2" in cell 15. The number "3" in cell 29. (every 14th cell)
Number "17" in cell 2. Number "18" in cell 16, number "19" in cell 30 (every 16th number)
They will all be down column A till the number 1100. (I have them in C and E to be able to see the pattern)
Is there a fill series or table or something that would be able to do this?