Like I said, I don't know *how* you're using your data, but copying that
formula down a column, and then eliminating the formula, leaving the random
numbers behind, gives you a list of random numbers that you can *USE* by
polling down that column, in the same way that you're using the return of
the single formula.

If you can do that (use the random numbers in the list), then you have
exactly what you're looking for, and you'll even know ahead of time, exactly
what random return will be used next.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"BaldySlaphead"
wrote in message
news:BaldySlaphead.1sgvzi_1121861306.506@excelforu m-nospam.com...

RagDyeR Wrote:
I don't know where or how you're utilizing the returns of your formula,
but
wouldn't simply copying it down a column give you the type of list
that
you're looking for?

You could remove the formulas, via <Copy - PasteSpecial - Values,
leaving
the random numbers behind.

I don't believe so!

Every time I refresh the data, the Rand will recalculate. For a bit of
fun, I wanted to record that the Rand had generated the result 1 ten
times, 2 seven time, 3 not at all etc etc.


--
BaldySlaphead
------------------------------------------------------------------------
BaldySlaphead's Profile:
http://www.excelforum.com/member.php...fo&userid=1260
View this thread: http://www.excelforum.com/showthread...hreadid=386779