Randbetween without repeat

[cmcfalls]

Greetings again,

Is there a way to get Excel to cycle through all numbers in
RANDBETWEEN function before repeating itself?

I may have to use VBA to do this, but I want a formula that will retur
a random valued between 1 and 100 (for this example) and NOT repeat AN
of the past values until the random function has run 100 times (thu
giving me a random number between 1 and 100 EXCLUDING those that hav
been returned within the past 100 cycles).

I am willing to do this with a cheat sheet (where the past rando
numbers are stored for exclusion) but do not know how to set this up
Thanks..

 

[Andy B]

Hi

Quick and dirty?
Create a column of numbers, 1 through to 100. Alongside, in the next column,
type =RAND() and fill down to the bottom. You can now sort on this column to
'mix up' the 1-100 column. Copy the range and Edit / Paste Special . .
Values to fix the values.

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/randint.html