Google Sheets - Random Number, Array & Item from a List 

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.

is there a way that i can hold the numbers? they are allways changing...

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.

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.

I only have one youtube channel with notifications enabled: you! thanks for the excelent content

How do you stop the number refreshing i.e. create an ID number that sticks

Thank youuuu

I didn't know about the randarray(). Thanks!

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.

i love your videos thank you very much

great

Thank you so much for all those lessons. I learned so much.

can google sheets have a column for height in feet & inches ?

I don't know how I ended up here but I like it.

THANKS! This was a life saver

Tanks you very much , can you make a video for the number of possible combinations (probability)

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.

Thanks for the great video. I was missing useful cases as an example

Thank you for yet another interesting function 😊 The only channel I have notification on

You saved the day... again! Much appreciated 🙏

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.

Thanks! Today I learned

great as usually! thank you!

Awesome like always!!!