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

[@GeorgePlaten]

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.

[@tannerbobanner9453]

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.

[@ExcelGoogleSheets]

Good suggestion.

[@SaintHanappi]

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

[@garychadwick1240]

Always interesting and you always cover all of the bases as well as instructing really well. Thank you.

[@indiogigante]

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

[@ExcelGoogleSheets]

Wow, thanks!

[@amok.4874]

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

[@Tepalus]

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

[@tilakdavidd2358]

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.

[@bielo3690]

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

[@ExcelGoogleSheets]

Thank You!

[@amaxlevin]

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

[@ExcelGoogleSheets]

😀

[@lpanebr]

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

[@fajeraaa8376]

i love your videos thank you very much

[@ExcelGoogleSheets]

Glad you like them!

[@Katawunga]

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

[@bruno_veloso]

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.

[@ExcelGoogleSheets]

=SEQUENCE(9, 1, 0, 1)

[@bruno_veloso]

@@ExcelGoogleSheets No way... more simple than i thought. I didn't know that formula. Neat! Thanks a lot for replying.

[@aviadbenhamo5812]

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

[@ExcelGoogleSheets]

:)

[@patrickschardt7724]

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

[@ExcelGoogleSheets]

:)

[@SantiiToorrez]

Thank youuuu

[@elissiaha2764]

THANKS! This was a life saver

[@dailyservers8336]

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

[@ExcelGoogleSheets]

Isn't it just exponent? ^

[@bzmin99]

Thanks! Today I learned

[@ExcelGoogleSheets]

Great!

[@davidfernandezbajo]

great as usually! thank you!

[@ExcelGoogleSheets]

Thanks!

[@DannyTheGFP]

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

[@marcobanderas3306]

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.

[@ExcelGoogleSheets]

Should be possible using RANDBETWEEN, SEQUENCE, SORT, VLOOKUP, but it would be quite complicated.

[@ai_dividend_daily_1]

great

[@nssdesigns]

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

[@ExcelGoogleSheets]

Use a script, NOT a formula.

[@stevenpineiro-cdot4671]

Awesome like always!!!

[@ExcelGoogleSheets]

Thank you! Cheers!