Select random names

[YOUNAN]

Hello,
I have two columns, I would like to pick up three names from every column randomly if possible every Thursday or any other way to achieve that .
Thanks in advance.

Younan

 

[Fluff]

Excel 2016 versio

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[YOUNAN]

Do you mind selecting the same person twice in x number of weeks?

How many names have you got?

That would be fine for me , thanks in advance

 

[Herakles]

I've developed a workbook to tackle this problem but I don't know how to make it available to you.

 

[YOUNAN]

I've developed a workbook to tackle this problem but I don't know how to make it available to you.

Thanks for your help, just post the formula here.

Best Regards