ock size if you set it to a very large number the calculation will
> last longer (varGroupSize that is set to 100).
>
> If you need to increase it you can.
>
> Regards!
>
> 2009/5/5 Michael Fowler
>
> Thanks Fabio.
>>
>> But, this doesn't take
Thanks Fabio.
But, this doesn't take into account only the range UNTIL the next blank. I
have made a sheet from your that shows three groups of data. The cell
calling the random data is taking into account ALL of the data. Can this be
limited to only each group and only to the next blank cell (aft
Yes, but I have multiple ranges in the worksheet (250+) with each range
having a different number of rows. If I use the index method:
=INDEX(A2:A171,RANDBETWEEN(1,169)), then I am forced to select the range AND
also to count how many total cells are in the range.
What I need to do is to do this by
I have a attached a sample file that includes cells (col. A) that I want to
get a random cell from. The blank cell above each of the two ranges is what
I want to use to extract a random cell from the cell range below it. The
range is always different and I am trying to do something like what I have
