AuthorJeremyCollier
New Member
- Joined
- Nov 11, 2016
- Messages
- 4
Hello all!
I'm at a loss on how to accomplish a static random return that will not change unless the user wants it to. Basically, I am trying to give a random result based on a selection in a list and need the random to not change again unless the user reselects Random. I'll be more specific below.
Dropdown list in A1 contains Yes, No, Random. If Random is selected, a random result picked from elsewhere in the workbook is displayed in B1. I've gotten this part to work fine with a combination of functions based around RANDBETWEEN, but the problem is the results changes every time anything else is changed in the workbook, as per the way RANDBETWEEN works, but I only want it changed if the user clicks on the dropdown list again and selects random again.
I've seen other similar (but not similar enough) questions around this and other forums, but I wasn't able to adapt it to my own need.
Sorry if I'm not very clear or left out important information. While I'm pretty good with excel when it comes to the functions, I have very little experience with manipulating things in ways that were not originally intended...
I'm at a loss on how to accomplish a static random return that will not change unless the user wants it to. Basically, I am trying to give a random result based on a selection in a list and need the random to not change again unless the user reselects Random. I'll be more specific below.
Dropdown list in A1 contains Yes, No, Random. If Random is selected, a random result picked from elsewhere in the workbook is displayed in B1. I've gotten this part to work fine with a combination of functions based around RANDBETWEEN, but the problem is the results changes every time anything else is changed in the workbook, as per the way RANDBETWEEN works, but I only want it changed if the user clicks on the dropdown list again and selects random again.
I've seen other similar (but not similar enough) questions around this and other forums, but I wasn't able to adapt it to my own need.
Sorry if I'm not very clear or left out important information. While I'm pretty good with excel when it comes to the functions, I have very little experience with manipulating things in ways that were not originally intended...