Excellent job. Easy to understand. The cool thing about the Microsoft 365 versions is: You can have a large set of master data and use INDEX MATCH or other lookup functions to create random smaller data sets Just match the random number to a position sequence
@TeachExcel3 жыл бұрын
Completely agree! And Match really is an amazing function too, even when used in VBA! (Just added some great features to the VBA course I'm finishing, all thanks to Match.)
@davethomas41813 жыл бұрын
Although random numbers are not something I would (typically) use on the job I really appreciate the insights into formula creation. Thank you Don!
@TeachExcel3 жыл бұрын
You're very welcome Dave! Oddly enough, this question about random numbers is one of the most common that I get asked, along with drop down lists.
@IvanCortinas_ES3 жыл бұрын
A great and complete tutorial. Thank you for sharing it!
@TeachExcel3 жыл бұрын
Thanks Ivan! Glad you think so) Next week is the complex formula explanation, so hopefully that will come out well.
@wayneedmondson10653 жыл бұрын
Nice! Cool tricks. Thanks for sharing :)) Thumbs up!!
@TeachExcel3 жыл бұрын
Thanks Wayne! :))
@darrylmorgan3 жыл бұрын
Some Really Cool Formulas Excellently Explained!Thankfully Microsoft 365 Makes Complex Formulas So Much Easier...Thank You Sir :)
@TeachExcel3 жыл бұрын
Thanks Darryl!! And hopefully, you will think the same about the complex formula explanation next week lol.
@ajpran3 жыл бұрын
thanks sir, it's works good, but what if with exclude number ?
@Excelambda3 жыл бұрын
Great video! Old and new school. A trick that I use when I generate random nr. to make them stop but keep them where they are. For ex: in B2 put "y" , in cell C2 =IF(B2="y",RANDARRAY(10,,1,100,1),C2#) . If we change B2 with "n" , will stop recalculating. New set of data? back to "y". Hit F9...F9....Like to keep a particular set, change B2 to "n" . Obs. If circular reference error, we need to go in Options , Formulas , tick ..Enable iterative calculations. Also could be cool to generate random words, random list selection.😉✌✌
@abbottkatz88303 жыл бұрын
Interesting point! It seems that if you simply leave B2 blank it also won't recalculate.
@Excelambda3 жыл бұрын
@@abbottkatz8830 It makes sense, recalculates ONLY for "y", I did it on purpose . Is easy to change for different behavior, as anybody likes.
@abbottkatz88303 жыл бұрын
@@Excelambda Either way, it's a very good tip - I didn't realize circular references could be managed this way.
@Excelambda3 жыл бұрын
@@abbottkatz8830 Thanks, is powerful but tricky😉👍
@TeachExcel3 жыл бұрын
I love this trick! And I feel sorry for the casual Excel user who opens one of your files on their computer and tries to blindly change some formulas hahaha
@Kolian12743 жыл бұрын
Hello dear Ihave 10 deferent numbers as Inout I want to see how many random number I can create from that 10 number For example my number is 03,05,07,11,13,15,17,19,21,23 Find out how many random number I can creat using above number Thanks
@UmuokpalaOcha3 ай бұрын
It can be a combination of 2 , 3 and 4 digit code
@yawsarpong45522 жыл бұрын
Please help me out; my English is poor but I hope you will understand me afterwards. I have 45 numbers and I want to group them into 3, which is 15 each. Now how can I you use 15/30 randomly.
@meetmaheshwari6173 жыл бұрын
Why I am getting a blank?😪
@kathyroberts77773 жыл бұрын
I hope somebody understood what you said, I am sorry I was not one of them! Wayyyy too advanced for me.
@TeachExcel3 жыл бұрын
No worries, check this week's tutorial and it might help out a bit! There, I break-down 5 techniques for making advanced formulas and then combine them to make the biggest formula from this tutorial. I'm not saying it is an easy tutorial, but it might help clear things up a little.