Is it possible to create a random generator with these requests?

[occhaos88]

system for random selection must be capable of

*selecting a code (6 digits) twelve (12) times during a thirty (30) calendar days
of enrollment.

*Each code's random selection schedule will either be a fixed
or fluctuating frequency.

“Fixed frequency”
means the code will be randomly selected from one (1) up to twelve (12) times
per month. For example, a code may be selected (2) times each month.

“Fluctuating frequency”
means the code will be randomly selected at varying frequencies from month to month.
codes may be entered as fixed/fluctuating initially, but can be changed at a later date.

Is this possible to do in excel?

[saravnepali]

Please Login or Register  to view this content.

will generate 6 digit random number

How do we tell excel when to generate random number ie the schedule

What is the logic