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
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
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
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?
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.
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?
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 - 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.
You have to go to your formula tab and put it on manual, then click Calculate Page and it will only calculate the page your on when you click that button.
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
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.
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!
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.
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
how do you get the add on for office 2016?
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
Good morning. Are you still answering questions? THX
OMG! Thank you so much!
Hi, Where can I get mrand function? Thanks
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
THANK YOU, THANK YOU, THANK YOU!! Worked like a charm the 1st time.
Can this be done now in newer versions of Excel, without the mrand function?
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?
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.
Can you create in latest MS excel? Mrand(), randomArray() are not working in excel 2016 +
Is there any way you can take a more granular approach instead of saying function keys?
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?
Can someone give me the current formula for this on excel or Google sheets?
Is this still working in 2018 with Excel 2016?
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 - 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.
Hi,
What did i do wrong with the mrand function. Everytime I hit enter or used a drop down, my random list changes.
You have to go to your formula tab and put it on manual, then click Calculate Page and it will only calculate the page your on when you click that button.
Hi How to use generate random number between two number without repeating numbers
Could you let me know from where can I download this excel (EMT302-306)
Mohanapriyan Rajendran people.highline.edu/mgirvin/excelisfun.htm and scroll down :-)
ctl and shift doesn't work to finalize the random selected numbers can you help
Thank you
You're welcome
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
Thank you, works but some columns have #REF! why?
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.
we don't have this function in excell in mac
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!
Not working please help
How can I get MRAND on my excel?
IF you are using Excell 2010 or 2013 you can use the RANDBETWEEN fx,
MRAND fx is part of the special Add-In for Excel and is now obsolete
Laza Lazarevic would you help me how to find Mrand in 2010
DONT WORK WITH 2016
Superlike
👍👍👍👍👍🌹