Skip number in sequence

Hey,

I'm doing this:

Please Login or Register  to view this content.

The values for CHOOSE are hard coded at the moment, but I need them to be dynamic. The count parameter for RandBetween is a cell value. This could change, and then in turn the number of values for CHOOSE.

If the start number is, in this case, 5, how would I get the next values to be mulpitples of 5? The start number can be anything, and is based on a rounded division of a total value and a count value.

So:

if the total is 68 and count is 11 the result is 6.18, rounded to 6. So there should be 11 multiples of 6 for the values for CHOOSE.

If the total is 70 and the count is 10, the result is 7. So there should be 10 mulitples of 7 for the values for CHOOSE.

Building the string of values I can do. But using that string (comma separated) in CHOOSE doesn't work.

Is that possible? To pass a dynamic number of arguments to CHOOSE?

Thanks!

I think this code can also solve the purpose...

Please Login or Register  to view this content.

Or are you specifically willing to use CHOOSE?

Regards
Sourabh

PS - I just saw that you are skipping a number in between, how to decide which number to skip?

Thanks for the reply.

This is what I've got so far. I've managed to ditch CHOOSE and use INDEX instead, as I can pass an array to it.

Please Login or Register  to view this content.

The only problem now, is the first element in the array is always blank, so the first number written out is blank.

If I change the For...Loop to start at 0, the first element is 0, not 6?

You can declare the array as follows-

Please Login or Register  to view this content.

This will begin from 1 not 0.

However, I am still curious to know why are you going into creating an array and then choosing a random number. We can even do it directly like this-

Please Login or Register  to view this content.

Does this not return the same?

Thanks. The Redim y(1 to count) works. I will try your other method and see how I get on.