Randbetween

J

jamesryan

Hi,

The version of Excel i'm using does not accept the RANDBETWEEN functio
so i am haveing to use the INT((RAND)*??)+1) function to get rando
numbers. Is there an add-on i can get to upgrade it or am i stuck wit
this?

Jame
 
D

Dick Kusleika

James

That function is in the Analysis Toolpak, it's not automatically part of any
Excel version. Go to Tools > Add-ins and check the Analysis Toolpak and it
should work for you.
 
M

Myrna Larson

It is part of the Analysis Tool Pack. Do you have it installed? If not, help
for the function tells you how to do that.
 
R

Rawley

Thanks to everyone for the answers - that helped me too. Question...why do
the numbers change everytime that you enter anything into any other cell? It
doesn't make any sense.

Thanks!
 
R

Rawley

Sorry, one other question - how can you make it so it generates a different
number each time. I entered in 1-40, but sometimes numbers repeat before I
pull it across 40 times. Can you "eliminate" a number somehow once it shows
up?
 
D

Dave Peterson

You could use a userdefined function.

J.E. McGimpsey has shared one with us:
http://www.mcgimpsey.com/excel/udfs/randint.html

And =Rand() and =randbetween() and even J.E.'s =randint() will recalculate each
time the excel recalculates.

If you need them to stay put, use those formulas and then
edit|copy and edit|pastespecial|values
 
J

JE McGimpsey

RAND() is volatile, meaning that it recalculates any time a cell in the
worksheet recalculates. Other volatile functions include TODAY() and
NOW().
 
J

JE McGimpsey

He could take out the Application.Volatile. Then it will only
recalculate when a Calculate All is forced...
 
Top