It's the perfect combination of being a good teacher, having loads of experience and full depth of knowledge of the subject. Thank you as always for sharing.
Hey! This was a great tutorial! When you want to update the sheet quickly, I’ve found that putting a checkbox and just flipping it on and off allows you to quickly update the sheet rather than having to type in cells.
I'm here again, awesome content as always. Thanks for sharing! I do not dare missing any video of you. I have a small challenge to accomplish which is: given a certain number (let's say 8) I need to populate the rows between [0;8 - given number]. The output is (dynamic - can be any given number): 0 1 2 . . . 8 It looks like the randarray functionality.
Some functions Google Sheets wins over Excel. In this case, Excel’s RANDARRAY is a lot better It’s still cool to see Google Sheets can do the same thing with some extra steps I am trying to learn both Excel and Google Sheets for work. Your tutorials are too notch
Is it possible to equally distribute a set of strings from a list? Let's say you have 100 clients in one row and a list of 5 representatives, and each of them has to be assigned randomly to 20 of them.
It's the perfect combination of being a good teacher, having loads of experience and full depth of knowledge of the subject. Thank you as always for sharing.
Hey! This was a great tutorial! When you want to update the sheet quickly, I’ve found that putting a checkbox and just flipping it on and off allows you to quickly update the sheet rather than having to type in cells.
Good suggestion.
As always: extra ordinary content. I love the way how you combine all those formula's in a way we all can follow. Thank you, Sir
Always interesting and you always cover all of the bases as well as instructing really well. Thank you.
Thank you so much for all those lessons. I learned so much.
I only have one youtube channel with notifications enabled: you! thanks for the excelent content
Wow, thanks!
I don't know how I ended up here but I like it.
You saved the day... again! Much appreciated 🙏
😀
Thank you for yet another interesting function 😊
The only channel I have notification on
Thank You!
Hi sir I have been your fan since I have started seeing the videos. Sir you are genious in teaching. Please teach Google data studio sir.
is there a way that i can hold the numbers? they are allways changing...
THANKS! This was a life saver
Thanks for the great video. I was missing useful cases as an example
:)
I didn't know about the randarray(). Thanks!
Thank youuuu
i love your videos thank you very much
Glad you like them!
great as usually! thank you!
Thanks!
Thanks! Today I learned
Great!
I'm here again, awesome content as always. Thanks for sharing! I do not dare missing any video of you.
I have a small challenge to accomplish which is: given a certain number (let's say 8) I need to populate the rows between [0;8 - given number]. The output is (dynamic - can be any given number):
0
1
2
.
.
.
8
It looks like the randarray functionality.
=SEQUENCE(9, 1, 0, 1)
@@ExcelGoogleSheets No way... more simple than i thought. I didn't know that formula. Neat! Thanks a lot for replying.
Awesome like always!!!
Thank you! Cheers!
Some functions Google Sheets wins over Excel. In this case, Excel’s RANDARRAY is a lot better
It’s still cool to see Google Sheets can do the same thing with some extra steps
I am trying to learn both Excel and Google Sheets for work. Your tutorials are too notch
:)
Tanks you very much , can you make a video for the number of possible combinations (probability)
Isn't it just exponent? ^
How do you stop the number refreshing i.e. create an ID number that sticks
Use a script, NOT a formula.
great
can google sheets have a column for height in feet & inches ?
Is it possible to equally distribute a set of strings from a list? Let's say you have 100 clients in one row and a list of 5 representatives, and each of them has to be assigned randomly to 20 of them.
Should be possible using RANDBETWEEN, SEQUENCE, SORT, VLOOKUP, but it would be quite complicated.