Forum Discussion

Copper Contributor

Feb 22, 2022

Solved

Random number generation

Hi everyone. I have been working on a formula that uses inputs that have been generated randomly (through RANDBETWEEN) to get to the result of this formula. Obviously, given that the inputs are rando...

excel

Formulas and Functions

cris_22
Feb 23, 2022
MS99MS if you are familiar with macros, here's one you can incorporate. If you are not, you can have 1000 RAND formulas, hitF9 to generate values, than copy and paste values only in another file/sheet

MS99MS

Copper Contributor

Feb 22, 2022

Thank you for your reply cris_22

How do I create the small macro to copy/paste (values only) in another tab?

cris_22

Brass Contributor

Feb 23, 2022

MS99MS if you are familiar with macros, here's one you can incorporate. If you are not, you can have 1000 RAND formulas, hitF9 to generate values, than copy and paste values only in another file/sheet

mtarler
Silver Contributor
Feb 23, 2022
alternatively if you have Excel365 you can just use RANDARRAY() and choose #row, #col, min, max and if it should be integers.
- cris_22
  Brass Contributor
  Feb 23, 2022
  mtarler OK, have to say that's really cool. Nice!