This is kind of a strange problem I'm having. I was hoping someone could elaborate on it.

I have a 2d array of numbers, lists 1-4. Right now when I loop I get something like this:

1
2
3
4
1
2
3
4
1
2
3
4
1
2
3

if I loop 15 times. Would it be possible to somehow get an output like this:
1
1
1
1
2
2
2
2
3
3
3
3
4
4
4

I'm still a bit green on vba loops.

You would need two loops... nested.

Edit: I just noticed that this is an Excel question. My questions remain, but I would not have replied had I noticed in time that it is posted in the Excel forum.

Original reply: How is the list generated? Perhaps the order could be imposed there instead of during the loop?

This post has been edited by BruceM: Feb 20 2012, 07:22 AM

This is a VBA in excel question.

I suppose that it could be done somehow onscreen if that was an option using excel to sort or something like that.

are you saying you want to have the numbers 1 - 4 generated 15 times each but sorted all 1s then 2s..... instead of 1-4 15 times ??

Yeah, pretty much.

Yep, I agree with Brian, 2 loops nested.

example:

a sample based on what everyone has contributed..

Hi,

Actually with some maths this can be achieved with just one loop:



You can also achieve the same result using functions:

=INT((ROW()-1)/4)+1

Type this into the first row and then copy down to row 15.

HTH
Stu

Cool but I need to do this in VBA

Hey folks. I decided to revisit this since I have hit another little snag.... How would I do this with multiple arrays with different precedence? In this case I have a series of arrays:

1
2
3

4
5
6
7
8

9
10
11

and if I want to set it up to fill out based on the first, then second, then third so if I had a need for 15 it would look like this:

1,1,2,2,3,3,4,4,5,6,7,8,9,10,11

I've been beating my head against a wall figuring this out