Help on Random Number Generation

[BhuSan]

Hi All,

My company decided to give gift card to customers. Just for 100 customers. Gifts are in 4 different types. My Company decided to give Type A gift to 50 customers . Type B for 25 customers. Type C for 15 and Type D for 10.

So I need to generate 100 random numbers which are non repeating and the total numbers should also match with each gift type. See the attached file.

Please help me.

 

[Luke M]

Hi BhuSan,

Here's out you can set it up. Generate the random numbers, and then use RANK to figure out which prize they got.

 

[NARAYANK991]

Hi ,

A search on this forum shows this :

http://chandoo.org/forum/threads/how-to-pick-the-10-data-from-list.20648

Surely once you generate 100 random numbers , you can decide that 50 of them will be allocated for Type A gift , 25 of them will be allocated for Type B gift , and so on.

Narayan

 

[BhuSan]

Very Impressive Thanks