Excel Magic Trick 302: Randomly Select Names No Repeats

Not working please help

Good morning. Are you still answering questions? THX

Can someone give me the current formula for this on excel or Google sheets?

OMG! Thank you so much!

👍👍👍👍👍🌹

Thank you

DONT WORK WITH 2016

Can this be done now in newer versions of Excel, without the mrand function?

Can you create in latest MS excel? Mrand(), randomArray() are not working in excel 2016 +

IF YOU HAVE EXCEL 2016, USE =RANDARRAY() INSTEAD. ITS THE EXACT SAME.

Great video! I followed it to the T with success! I chose 30 random winners for a t-shirt with no issues. Thanks so much.

This helped me immensely. What I am curious about is. You mean it would never repeat a combination? Ever?! Irrespective of how often I press F9? I am not too sure how possible this is. Can you expand on this?

I have used this for Horseshoe tournaments in which we play 7 rounds and draw a different partner every round. I do find we have repeat partners and if you have an odd number of people and need a bye the formula doesn't know what to do. Any suggestions?

how do you get the add on for office 2016?

Hi,
What did i do wrong with the mrand function. Everytime I hit enter or used a drop down, my random list changes.

Is this still working in 2018 with Excel 2016?

we don't have this function in excell in mac

Superlike

Hi, This trick would be super helpful for work, however, the morefunc download you mention at the start doesn't work on 2010 versions with 64-bit. Could you suggest any other options without using Mrand please?
Thanks!

Using this exact same example, how would you write a single cell formula that tells you the probability of selecting two specific names from that given range?

Hello, this is exactly what I need to do and this video is very helpful (as all your other videos). However, given that I am using Excel 2013, is there an updated video for this random name selection that uses Randbetween or something that can work with Excel 2013? Thank you!

Hi, just for fun: in E2 to be copied across could be a different approach:
=INDEX($B$8:$B$23,IFERROR(AGGREGATE(15,6,ROW($8:$23)-MIN(ROW($8:$23))+1/((COUNTIF($D$7:$F7,$B$8:$B$23)=0)*(COUNTIF(D$8:D8,$B$8:$B$23)=0)),RANDBETWEEN(1,COUNTA($B$8:$B$23)-1-COUNTA($E$7:$F7))),""))

Hi, Where can I get mrand function? Thanks

Is there any way you can take a more granular approach instead of saying function keys?

ctl and shift doesn't work to finalize the random selected numbers can you help

I downloaded the MoreFunc file and add it to the Excel Add-ins but the MRAND function wasn't included I found MROUND but no MRAND can you help me please, thank you

HI - great tutorial. BUT...
Im am faced with a teammaking task, where I have to include at least 2 boy and 2 girls in a 5 man team. Further more the teams have to rotate 5 times in such a way that (if possible no one will be on the same team twice.)

Is there af solution for that ?
Thanx in advance.

Could you let me know from where can I download this excel (EMT302-306)

Hi How to use generate random number between two number without repeating numbers

How can I get MRAND on my excel?

I am not sure of the top of my head. Try this site: mrexcel [dot] com/forum There are a few Excel Statistic Masters at this site that may be able to help!

I am a great fan of all your videos - I find them fun and informative. However I am stuck on a problem and think this video is nearest to what I'm looking for. I'm creating a 5 day golfing schedule for 12 players - this means there are 60 cells to fill. I want everyone to play with each other once but then have the minimum of repeats. I've tried the MRAND with INDEX which if great for each day's play but then find there are a lot of repeat groups on other days. Any advice VERY welcome.

Install the morefunc.exe, then open excel 2010, click the file tab, then click options, in the new window click Add-Ins at the bottom you'll see excels add-ins click in go, in the new window click browse and then look for the folder where you install morefunc, in the folder choose the first file and then click ok, browse again choose the second file and click again do the same with the last file, after that just click ok now you can use the morefunc functions in excel 2010

No I do not. I have tried to get MoreFunc towork in 2010, and even with advice from some Excel pros who tell me that MoreFunc does work in 2010, I cannot get it to work. It is really too bad though, because MoreFunc is so useful. You can try posting question to: mrexcel [dot] com/forum; there you can get help with how to make it work in 2010 or maybe some VBA code that help.

You are great, is there any way you could randomly have each person play each other once but not repeat the fixture for e,g i have 6 teams in 1 group, say Team A, Team B, Team C, Team D, Team E & Team F. I want to be able to randomly have each team play each other once but not repaet the fixture and also not have the teams who have played to play straight away e.g Game 1 is Team A VS Team 6, I dont want team A to play in Game 2 straight away as they have already played in game 1. Please Help

Dear PrincessWithSkills, It is not the INDEX, it is the MRAND that is generating random numbers without repeats. You have to get MoreFunc Excel add-in to have this function. The INDEX just uses the numbers that MRAND is generating. --excelisfun

Dear serzantas, I am glad that you like them1 --excelisfun