Random Name from List in Google Sheets

How to get random name from list?
In this video, you'll learn formula to pick a random name.
Formula - www.theakshay....
Connect with me on :
✅ My Website : www.theakshay.in
💙 Twitter : / the_akshay_1
💛 Instagram : / the_akshay_1
📕 Quora : www.quora.com/...
Google Sheets All Tutorials (playlist) ▶ • Learn Google Sheets
#GoogleSheets
Learn Google Sheets with The Akshay

[@ioanavoine]

Such a simple, elegant solution! That was very helpful! Thank you very much!

[@TheAkshay]

I'm glad you liked it

[@lillianrightmasika1546]

Lets say, i want names that start with a and end with y, how do i apply the filter on that?

[@ShenderRamos]

great video short and well explained

[@TheAkshay]

Thank you

[@franciscocataldo9238]

Just what I needed

[@TheAkshay]

Glad to help

[@sssssssss111]

Very helpful thanks

[@TheAkshay]

Thanks for letting me know you found it helpful.

[@akaaaaaaa]

thanks so much😁😁

[@TheAkshay]

You're Welcome

[@trazzel3746]

I don't get this to work in my spreadsheet. The function "counta" is the thing that is not working I belive.

[@TheAkshay]

COUNTA is a function and available in Google Sheets and Excel.

[@trazzel3746]

​@@TheAkshay I think I got it now, but can I add some weight in the lottery? Say that someone buys two tickets and I dont want to repeat their name?

[@TheAkshay]

You can remove duplicate names first

[@trazzel3746]

@@TheAkshay aha okey, and how to I get their ticket number to be worth x2?

[@TheAkshay]

=IFERROR(match(indirect("A"&randbetween(1,counta(A:A))),C:C,0),"Refresh")