Random sampling but taking into consideration multiple fields

[JP_1]

Hi there,

I am looking to sample based on a unique field but don't want to sample a person more than once.  I hope that makes sense but I have put a basic example of the data I am working with below.  E.g. I want to randomly select/sample 3 rows but do not want to sample a name more than once.  So if in the random sample AB345 Alex was selected/sampled, then no more Alex's should be part of the sample.  There should be three unique names in the sample.

I have tried a few things but unfortunately cannot get to the answer - would appreciate the help please.

UNIQUE FIELD	NAME
AB345	Alex
GF458	Brad
DC367	Charlie
VG689	Dave
FG234	Ethan
AV001	Charlie
YT534	Brad
FE123	Dave
LF823	Dave
PF287	Alex
RT987	Charlie
LL433	Dave

[shwtswnt]

Hello,

i have this  below mentioned table. looking help for how to collect sample as per table. table data will change dynamically as Highest  and Random numbers will keep changing. i have raw data file where we have Region, Source Highest $ amount and Random Column now want to fetch data / rows following this table dynamically. Tried with batch macro but not able to do the same.

Region	Source	Highest	Random
USA	Apple	1	0
UK	Lemon	13	4
UAE	Apple	5	6
USA	Lemon	8	7
Null	Apple	1	0