Randbetween

[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

 

[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.

 

[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.

 

[Guest]

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!

 

[Guest]

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?

 

[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

 

[JE McGimpsey]

Take a look here:

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

 

[JE McGimpsey]

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

 

[JE McGimpsey]

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