Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save RAND select number
Hello,
I want to use RAND BETWEEN to pick a random number from a list - and then save it so it will not recalcutate. My intention is to use it as a way to randomly select a winner of a drawing. I tried to password protect the work sheet, but that didn't work. And, I'm not sure why. Is there a way to randomly select a number, row or cell and NOT have it recalculate? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save RAND select number
You could copy and paste value.
"RC" wrote: Hello, I want to use RAND BETWEEN to pick a random number from a list - and then save it so it will not recalcutate. My intention is to use it as a way to randomly select a winner of a drawing. I tried to password protect the work sheet, but that didn't work. And, I'm not sure why. Is there a way to randomly select a number, row or cell and NOT have it recalculate? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save RAND select number
I actually tried that on a second workskeet, but that didn't work either.
And, for legal purposes, I'd have to be able to show that a formula was used to pick the number...so you can see how recalculating presents a problem... Thank you for your response though. "rook" wrote: You could copy and paste value. "RC" wrote: Hello, I want to use RAND BETWEEN to pick a random number from a list - and then save it so it will not recalcutate. My intention is to use it as a way to randomly select a winner of a drawing. I tried to password protect the work sheet, but that didn't work. And, I'm not sure why. Is there a way to randomly select a number, row or cell and NOT have it recalculate? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save RAND select number
Here is one possible solution... It is a UDF that takes 2 cells (the between
values) as inputs and returns a random number. Change either of the two cells and the formula re-calcs... Public Function StatRandBetween(ByVal Cell1 As Range, _ ByVal Cell2 As Range) As Long StatRandBetween = Round(Abs(Cell1.Value - Cell2.Value) _ * Rnd + Application.Min(Cell1, Cell2)) End Function Place this in a Standard Code module (the same place that recorded macors reside). It is used like this... =StatRandBetween(A1, B1) Change A1 or B1 and it re-calcs... Otherwise it's static... -- HTH... Jim Thomlinson "RC" wrote: Hello, I want to use RAND BETWEEN to pick a random number from a list - and then save it so it will not recalcutate. My intention is to use it as a way to randomly select a winner of a drawing. I tried to password protect the work sheet, but that didn't work. And, I'm not sure why. Is there a way to randomly select a number, row or cell and NOT have it recalculate? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non updatable Unique Random Number | Excel Worksheet Functions | |||
Changing a Number in a Column Using Arrays | Excel Worksheet Functions | |||
How do i save a 12 digit number in a .csv document in excell? | Excel Discussion (Misc queries) | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Auto save with a numerical number | Excel Discussion (Misc queries) |