Random Number Generator

[ryan8200]

I need the kind assistance from Excel expert in the forum.

How to generate random number between 1 to 36 based on numbers from 0000 to 9999 ?

Anyone can give some tips to proceed ?

Thanks.

 

[mikerickson]

I'm not sure what you mean by generating a random number based on some other number, but the RANDBETWEEN function sounds like it might do what you want.