If you are using Excel 2003 you shoul access Insert>> Name >> Define then
you cal select varGroupSize and edit it.
If you´re using 2007 just goto Formulas >> Name manager
then you cal select varGroupSize and edit it.
Regards!
2009/5/5 Michael Fowler
> Thanks. My data is mostly larger than
Thanks. My data is mostly larger than 100 cells. how can I increase the
varGroupSize to 200?
Thanks,
Mike
On Tue, May 5, 2009 at 2:38 PM, Fabio Lemos wrote:
> Ok.
> That's possible too...
>
>
> There is a named range (a value in this case) that put a limit on each
> block size if you set i
Ok.
That's possible too...
There is a named range (a value in this case) that put a limit on each block
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 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
The formula was wrong, see this new file.
2009/5/4 Fabio Lemos
> you could create a variable range name and use it in your formula...
>
> 2009/5/4 Satti Charvak
>
> Prepare en excel sheet and send it back...your usage of the formula is not
>> clear.
>>
>> On Mon, May 4, 2009 at 7:05 AM, Blank
you could create a variable range name and use it in your formula...
2009/5/4 Satti Charvak
> Prepare en excel sheet and send it back...your usage of the formula is not
> clear.
>
> On Mon, May 4, 2009 at 7:05 AM, Blank wrote:
>
>>
>> I am trying to get a random selection of a cell containing t
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
Prepare en excel sheet and send it back...your usage of the formula is not
clear.
On Mon, May 4, 2009 at 7:05 AM, Blank wrote:
>
> I am trying to get a random selection of a cell containing text,
> basically:
>
> IF there is an empty cell in a column, get a random cell of data from
> the range b
