Your tutorials are totally worthwhile. I don't know if I will ever need this, but this video is so memorable that I will recall it if and when the need arises..!
Wonderful info, Leila. I was scratching walls to create vba or macro in order to refresh the numbers, but your F9 method which I just tried on my random number generator works perfectly! It made my life a lot easier, and besides you teach a lot of some other important excel tricks. Thank you very much . . . .
You are the best in this field. Thank you for sharing the knowledge and working so hard to present it excellently. Everything is so smoothly presented precise, concise and on point.
Thank you. I needed this for tutoring kids for time tables. This is truly amazing. So simple buy I didn't know how until I saw this. Lovely lady you are. :)
Nice to see that I am not the only one who is still learning, I would love for you to do a "simple😂😂" googlemaps type route/distance calculator between two business locations. Love your channel.
we have now google sheets and the excel web app. a comparison would be fine... maybe in more than just one vid. there is surely something google sheets can, and excel can't... and ofc vice versa. that would be a cool topic, if you are searching for some future topics 😁👍 thank's anyway for your work
A Great technique. Now I understand the entire content properly. Thanks once again Madam. May I also request you to please upload the video regarding creation of random letterrs and A TO Z alphabets.
Hi Leila, honestly, I never knew about how powerful Excel is and your channel helped me realized that. I have one question tho, I have to ask the professional. How did you create that animation at 0:23?
Hmmm, just when I think I know enough of a feature in Excel, Leila ensures that I don't and what a boon it is really! Thanks again Leila for showing what is possible with random numbers! Nice video! 😊👍
Thank you for your perfect explanation, in case I need to select the value randomly but just for many specific values I would specify them taking the percentage of repeated values that I will define, into account, what can I do? thank you
Good job Liela, good job 👌🏽 Never regret watching your videos, the topic seems familiar to me, all functions you mentioned are well known to me and I'm using them frequently, but yet I opened the video! Not surprisingly, I found something new and interesting too! Looking forward to that one day for me opening your videos and learn nothing, I guess I will spend a lot of time until then!
Hi Leila, Thank you for the video. I've created a times table sheet for my daughter. It includes so much like a timer, score keeping, auto calculations etc etc etc.... and put in a lot of effort to write the macros. But now I'm stuck. I would like to randomize some of the cells without repeats and this is all possible in your video. But what can I do to prevent the randomized cells from changing when typing in other cells. I only want the random numbers to change if she press F9. Is it possible? So basically, I want her to press F9 (Refresh), complete the times table. Once done she only needs to refresh again for a "different" times table. As it is completely automated with the press of one button I don't want to COPY and PASTE SPECIAL VALUES. Your input will be greatly appreciated! Christo (South Africa) ----- EDIT------ I was able to achieve this to change the Calculations Options to Manual, and Creating a "Reset Macro". But your video helped a lot in my quest to randomize the numbers and to reset to a new and different question sheet with a press of a button),
Hi mam Your all lessons are amazing. I have a question that is 10000 is my total sale. I want to convert this value into 15 days but without repeating. Pls suggest which formula will apply.
I know it is not so interesting but that UNIQUE(RANDARRAY(...)) problem does not seem to occur when we create a horizontal rather than a vertical array of random numbers. Of course, I could be wrong but I have simulated a horizontal array hundreds of times and have yet to see a #SPILL! error. whereas a vertical array of numbers generates the error very frequently However, you can also contrast =UNIQUE(RANDARRAY(10,,10,20,1)) with =UNIQUE(RANDARRAY(50,,10,20,1)) by way of a possible solution to the problem ... although I appreciate your SORTBY(... and other solutions to this problem are more foolproof!
Rand() function works randomising values from a uniform distribution. But what about getting random numbers from another kind of distribution - normal, Poisson, etc?
Hi Leila, Is there any way to generate all possible combinations of multiple numbers for instance if I want all possible combinations of numbers 1,2 and 3 I know the total possible outcome is 6 by using the Combin function but I also want to know the possible combinations that are 1,2,3. 2,3,1 3,1.2 1,3,2 2,1,3 3,2,1
I have Office 365 and noticed that random number generator, which I created years ago, no longer recalculates when I depress F9. Through some experimenting on the keyboard, that the Function key + F9 now recalculates my 60 fields for random numbers. Just and FYI. Thanks for your videos.
We can get random number by using data analysis tool in excel. Add data analysis tool by add ins, then select random number generator - select uniform - give min and Max number to get data in Excel
Hi Leila, This is a great tool but my version of Excel does not have the "=unique(randarray", "=rand(array) or "=sequence" functions. is there another way to use those functions? Thanks so much
Leila- I have a list of 10 companies and each company has 5 or more contacts. I wish to assign the same number to the first contact of each company. For example- Assign #1 to the first contact of each company. Assign #2 to the second contact of each company. So on and so forth for the rest of contacts
Can you do a video on best practices for storing important emails outside of outlook? The company i work for rolls emails off after 90 days. Projects I work on can last all year and email has lots of history in it related to projects that I sometimes need to reference....like proof of project decisions made. How do you extract important emails? What are best practices for organizing and storing them so I can find them long after that 90 day retention threshold is hit. Thanks.
Leila, Thanks for the videos, appreciated very⁹ much!! How do I go about with a list of names say for team peer to peer review. The output needed is a list of "Peer to Review" from team list, Noting that ; a. You can't review yourself and, b. Each member has to participate. Thanks in advance.
Hi Leila, I am using a combination of CHAR and RANDBETWEEN functions to generate a random password of 10 character starting with Capital and a mixture of Alphanumeric and special characters but whenever the spreadsheet refreshes it changes the values and I like to keep the values. =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(35,38))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(60,63))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(101,989)
Unique + RANDARRAY suits my needs just fine - but why does it not always output x n number of results (ie 10 as you defined - though sometimes you get less than 10 numbers...) Also, what triggers the spill error?
Grab the file I used in the video from here 👉 pages.xelplus.com/random-number-generator-file
Le rythme, les explications tout est parfait. C’est la première fois que je planche sur Excel à cette heure de la nuit sans m’endormir !!!! Bravo.
Once again you have proved that I have a lot more to learn with Excel!
There's always more to learn :)
@@LeilaGharani this makes me more happier 😀
I'm making my own Number Sense practice sheets, and the Google searches I've seen explain these functions so poorly; this video was a lifesaver
Your tutorials are totally worthwhile. I don't know if I will ever need this, but this video is so memorable that I will recall it if and when the need arises..!
Hi Leila I have been following you for about 18 months thank you so much for taking my Excel knowledge to the next level
thank you literally no one else could explain it but you
Wonderful info, Leila. I was scratching walls to create vba or macro in order to refresh the numbers, but your F9 method which I just tried on my random number generator works perfectly! It made my life a lot easier, and besides you teach a lot of some other important excel tricks. Thank you very much . . . .
Glad it was helpful!
This is the best explanation I have seen on the rand function so far...Thanks a lot!
Glad it was helpful!
You are the reason why I don't rank my Excel skills as a 10 out of 10. Thank you 🙂
😁
even she's learning
This is so convenient. Thank you so much for putting all these in one place, you rock!
Many thanks for the clear explanation, Leila!
Thanx a lot mam,I found solution to one of my problem I was stuck in since long from your this video. Thanx a lot
You are the greatest, Leila. I had not thought of using unique with randarray yet.
Your lessons are amazing! I totally love it. The explanations , presentation, content everything is on point!💯
Thank you! I appreciate that!
I learned a lot about rand function. I love you.
You are the best in this field. Thank you for sharing the knowledge and working so hard to present it excellently. Everything is so smoothly presented precise, concise and on point.
Wow, thank you!
Mam your teachings are very helpful. Thanks a load for your effort.
Thank you. I needed this for tutoring kids for time tables. This is truly amazing. So simple buy I didn't know how until I saw this. Lovely lady you are. :)
Nice to see that I am not the only one who is still learning, I would love for you to do a "simple😂😂" googlemaps type route/distance calculator between two business locations. Love your channel.
we have now google sheets and the excel web app.
a comparison would be fine... maybe in more than just one vid.
there is surely something google sheets can, and excel can't... and ofc vice versa.
that would be a cool topic, if you are searching for some future topics 😁👍
thank's anyway for your work
...
FELICITACIONES x TUS VIDEOS!!
CONGRATULATIONS FOR YOUR VIDEOS !!
ERES UN EJEMPLO A SEGUIR!!
YOU ARE AN EXAMPLE TO FOLLOW !!
Thank you Leila. Finally! A useful formula to help me pick the random winning Powerball numbers 😁
So happy with this. I saved this one 👍🏻. Thank you!!
THANK YOU DEAR LEILA JAN, YOU ARE HELPFUL AND AWESOME LECTURER.
A Great technique. Now I understand the entire content properly. Thanks once again Madam. May I also request you to please upload the video regarding creation of random letterrs and A TO Z alphabets.
This is randomly awesome 😆
Thank you, Leila for all of these amazing tutorials. They are very much appreciated! :)
Glad you like them, Dave!
The one of excel expert
Hi Leila, honestly, I never knew about how powerful Excel is and your channel helped me realized that. I have one question tho, I have to ask the professional. How did you create that animation at 0:23?
That's prepared with Premier Pro and After Effects.
thank you SOOOO much! I needed this for my experimental design and it worked perfectly!
Thanks for the "random" video full of neat surprises!
Thanks Leila. Solved my problem as always
Hmmm, just when I think I know enough of a feature in Excel, Leila ensures that I don't and what a boon it is really! Thanks again Leila for showing what is possible with random numbers! Nice video! 😊👍
Glad you found something new, Vijay!
Cool... I now know how to generate Random Numbers without repeats! THanks! 🙂
Glad it helped!
Love it, thanks Leila!
Added to my list of Excel Wizardry.
Great video. This has helped me, along with a lookup formula, to create a random staff rota.
Glad it was helpful!
Thank you for your perfect explanation, in case I need to select the value randomly but just for many specific values I would specify them taking the percentage of repeated values that I will define, into account, what can I do? thank you
Hi Leila, if you need to create random numbers daily/weekly, is there a way to ensure they don't repeat over time?
Handy tips as always Leila, very intuitive, thanks for sharing
My pleasure, Darren!
Thanks a lottttt, specially for decimals
Most welcome 😊
Good job Liela, good job 👌🏽
Never regret watching your videos, the topic seems familiar to me, all functions you mentioned are well known to me and I'm using them frequently, but yet I opened the video! Not surprisingly, I found something new and interesting too!
Looking forward to that one day for me opening your videos and learn nothing, I guess I will spend a lot of time until then!
Happy to hear you found something new!
Great as Always --- as a part time Bingo caller I can see my spreadheet random number generator changing in the near future
Hey!
Many thanks once more! Always with super accurate and straight forward examples!! Keep going the good work :)
So cool and useful in randomly choosing next weeks Powerball numbers 🔮 🎰 💰
Hi Leila,
Thank you for the video.
I've created a times table sheet for my daughter. It includes so much like a timer, score keeping, auto calculations etc etc etc.... and put in a lot of effort to write the macros.
But now I'm stuck.
I would like to randomize some of the cells without repeats and this is all possible in your video.
But what can I do to prevent the randomized cells from changing when typing in other cells. I only want the random numbers to change if she press F9. Is it possible?
So basically, I want her to press F9 (Refresh), complete the times table. Once done she only needs to refresh again for a "different" times table.
As it is completely automated with the press of one button I don't want to COPY and PASTE SPECIAL VALUES.
Your input will be greatly appreciated!
Christo (South Africa)
----- EDIT------
I was able to achieve this to change the Calculations Options to Manual, and Creating a "Reset Macro". But your video helped a lot in my quest to randomize the numbers and to reset to a new and different question sheet with a press of a button),
Thank you! You are very talented and easy to understand!
Wow, thank you!
Hi mam
Your all lessons are amazing. I have a question that is 10000 is my total sale. I want to convert this value into 15 days but without repeating.
Pls suggest which formula will apply.
Great one again, Leila!
I know it is not so interesting but that UNIQUE(RANDARRAY(...)) problem does not seem to occur when we create a horizontal rather than a vertical array of random numbers. Of course, I could be wrong but I have simulated a horizontal array hundreds of times and have yet to see a #SPILL! error. whereas a vertical array of numbers generates the error very frequently However, you can also contrast =UNIQUE(RANDARRAY(10,,10,20,1)) with =UNIQUE(RANDARRAY(50,,10,20,1)) by way of a possible solution to the problem ... although I appreciate your SORTBY(... and other solutions to this problem are more foolproof!
Cute technique. Thanks for sharing ☺️
Thanks. Please show how to select random work orders and value of data. Please. Thanks
Can I use Randbetween with unique to get non repetitive numbers?
Thank you so much 💓
You are awesome. You have really helped me a lot I am impressed how these small changes can now help me with my data
Great to hear!
Just simply awesome 👍
Just what I was looking for…perfect timing thank you so much.
Great tutorial as always. Thanks for sharing
Cool, Leila!!! Thanks! That was one I needed 😀👍👍👍
Wow... Very nice explain.
many thanks
Rand() function works randomising values from a uniform distribution. But what about getting random numbers from another kind of distribution - normal, Poisson, etc?
Hi Leila,
Is there any way to generate all possible combinations of multiple numbers for instance if I want all possible combinations of numbers 1,2 and 3 I know the total possible outcome is 6 by using the Combin function but I also want to know the possible combinations that are
1,2,3.
2,3,1
3,1.2
1,3,2
2,1,3
3,2,1
Very useful while making roster for team..
Amazing as always
Thank you! Cheers!
Thank you! :)
Do you have plans to do a Power Automate Desktop course?
This is great, how can do I a random sequence for say 24 rows but within those rows are random numbers from 1 to 36 ?
I have Office 365 and noticed that random number generator, which I created years ago, no longer recalculates when I depress F9. Through some experimenting on the keyboard, that the Function key + F9 now recalculates my 60 fields for random numbers. Just and FYI. Thanks for your videos.
We can get random number by using data analysis tool in excel. Add data analysis tool by add ins, then select random number generator - select uniform - give min and Max number to get data in Excel
Really handy tips 😉 I was looking for that for a while 🤗 thank you Leila
You’re welcome 😊
Hi Leila..Please explain how to write Macros for csv formatted files..
Thank you.
Hi Leila, This is a great tool but my version of Excel does not have the "=unique(randarray", "=rand(array) or "=sequence" functions. is there another way to use those functions? Thanks so much
Leila- I have a list of 10 companies and each company has 5 or more contacts. I wish to assign the same number to the first contact of each company. For example- Assign #1 to the first contact of each company. Assign #2 to the second contact of each company. So on and so forth for the rest of contacts
Hi
Thanks for easy to understand video
Can you tell me how I can creat 5 digit random numbers between 10 to 30
VERY NICE 👍👍
Hi... Plz guide how to concatenate two cells by keeping the text color format?
thank you so much
Thankyou. How do I freeze those randomly created numbers so that they don't change ever?
Thanks excellent tutorial
Glad you liked it.
Thank you mam..
Nice Video!!
Can you do a video on best practices for storing important emails outside of outlook? The company i work for rolls emails off after 90 days. Projects I work on can last all year and email has lots of history in it related to projects that I sometimes need to reference....like proof of project decisions made. How do you extract important emails? What are best practices for organizing and storing them so I can find them long after that 90 day retention threshold is hit. Thanks.
Thank you so very much. This was a great video!!!
Glad you enjoyed it, Daryl!
Good video :) Any nice tips for random names as well ?
Thank you
Superb 👌
Hello Can you show us how to do the same thing but with a Excel attachment?
Mam I don't understand why hash spill error come but other concepts were crystal clear
Maybe this will help: ua-cam.com/video/sFn0gE_y1U4/v-deo.html
Cool! That'll definitely be helpful! 😃
Great job! But Same topic already available.
Fantastic tric
Thank you so much Mam
God bless you with your fmly
Leila, your video is amazing. Thanks so much. Can you explain how to make a sort number by group of columns (example: by area)
Leila, Thanks for the videos, appreciated very⁹ much!!
How do I go about with a list of names say for team peer to peer review.
The output needed is a list of "Peer to Review" from team list,
Noting that ;
a. You can't review yourself and,
b. Each member has to participate.
Thanks in advance.
Hi Leila, I am using a combination of CHAR and RANDBETWEEN functions to generate a random password of 10 character starting with Capital and a mixture of Alphanumeric and special characters but whenever the spreadsheet refreshes it changes the values and I like to keep the values.
=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(35,38))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(60,63))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(101,989)
Unique + RANDARRAY suits my needs just fine - but why does it not always output x n number of results (ie 10 as you defined - though sometimes you get less than 10 numbers...) Also, what triggers the spill error?
Thanks
Do you have a playlist related to Excel in which you have completed excel from scratch? plz reply asap, I like your videos by heart
@@user-rm1im2od5b don't you on telegram?
Great for Monte Carlo simulations.