Random Unique Value Generator Based On Sample Size And Maximum Items Limit

[bmbalamurali]

Hi All,

Thanks for your precious time in supporting me, my need is that i have a set of reference number in my excel sheet and i have desired counts (sample size) that i need to randomly select from the set of reference numbers and allocate them to few persons in next sheet (that i will be input their name and how many reference numbers should be allocated to a particular person, the persons and their count will change daily)

I uploaded my sample workbook, please download and help me in this regard.

Pls come back if any of my explanation is not understandable.

Once again thanks for your precious time.....friends...`



i have already posted this thread in excel forum for reference pls see below

Need to organize data based on requirements....explained below

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA