Mr Excel & excelisfun Trick 11: Randomly Select A Name

[cedricluma]

Hello ExcelIsFun. Thanks for the great videos.

I have a set of 3000 employees ID.

I would like to RANDOMLY select 4 different sets of 500 different employees to administer 4 diff surveys.

I tried randbetween and got the first set (I ran the formula several times until i get the first set of diff employees)== which i "copied values" to a different sheet

Now i'm not sure how to extract the first set i got from my original data so as to be able to reuse randbetween for the 2,3,4th sets THX

Cedric

[ExcelIsFun]

Post your question to THE best Excel site around:

mrexcel[dot]com/forum

You will be able to get some VBA code for that task.

[cedricluma]

@ExcelIsFun  Thank you. I just did. Hope to get a response. Thanks again for all the great videos.. Very helpful.

[emest24]

I think this is really cool, man ~~

but anyway, how to do this without repeating the name appear in column?

[ExcelIsFun]

Try these video titles:

Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions

and

Excel Magic Trick 302: Randomly Select Names No Repeats

[gurtej176]

grt

[ExcelIsFun]

Dear gurtej176,

EXCELlent!!!

--excelisfun

[firaangi]

I agree, We are all winner here. It is an excellent way to learn Excel. Keep up the good work, Bill and Kike.

[ExcelIsFun]

Dear firaangi,

I am glad that you like it!

--excelisfun

[tirathmistry]

Awesome video

Thanks a lot to Both the Genus of excel

Love to your both videos

Keep up good work

God Bless you :-)

[ExcelIsFun]

Dear tirathmistry,

Thank you for watching!

We'll keep making them!

--excelisfun