ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I randomly select values from an array with removal? (https://www.excelbanter.com/excel-discussion-misc-queries/176987-can-i-randomly-select-values-array-removal.html)

bvc

Can I randomly select values from an array with removal?
 
I am trying to set up a random value generator with removal of the selected
values.
Is there a way to accomplish this?

Niek Otten

Can I randomly select values from an array with removal?
 
Maybe this?

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bvc" wrote in message ...
|I am trying to set up a random value generator with removal of the selected
| values.
| Is there a way to accomplish this?



bvc

Can I randomly select values from an array with removal?
 
This works great. Thanks for the tip.

bvc

"Niek Otten" wrote:

Maybe this?

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bvc" wrote in message ...
|I am trying to set up a random value generator with removal of the selected
| values.
| Is there a way to accomplish this?





All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com