Random Name from List in Google Sheets || Select Random Number 

That is such a great use for this function @irmareyes9805! Thank you for sharing ( ＾◡＾)っ

Thanks @Stencilpirate, You could create a function or a button that would do that, but it . Here is a forum discussion and code: An easier solution is to make like typing a letter or deleting a letter in any cell or refreshing the sheet. Manual but still effective. ( ＾◡＾)っ Cheers!

Thank you so much @TheQuizzyMind!. 🍀

Hi @princer2885, You would have to either create a Script or a Macro, which can, unfortunately, be complex. Here are couple of forum discussions that I found that talks about how to do it. stackoverflow.com/questions/32290795/run-function-on-button-click-as-the-creator-user-google-spreadsheet shorturl.at/vbb1P www.reddit.com/r/excel/comments/rxgpgk/run_formula_when_button_pressed/ Good Luck🍀

idk if this was what you were looking for but i just put a checkbox above and used =if([ABOVE CELL]=true,index('[RANGE],RANDBETWEEN(1,counta('[RANGE]))))

Hi, I see the problem. You would have to modify the formula as follows: 1. Enter the Rand formula in B2, and copy it down the column: 2. Put the below formula in C2 to extract a random value from column A: 3. Copy the above formula to as many cells as you want selected. Here is a much better step-by-step explanation. Scroll down to the "How to randomly select in Excel without duplicates" section: www.ablebits.com/office-addins-blog/excel-random-selection-sample/?AVGAFFILIATE=55741&__c=1 Good Luck🍀

Hi @dakotahedwards1670, There are two ways you can lock or keep track of the winners: 1. You can either COPY & PASTE VALUES to another place or Tab; or 2. Take a screenshot Here is a Google Sheets response; they also mention using scripts, but that is a more advanced solution. support.google.com/docs/thread/8555804/randbetween-result-convert-into-static-numbers?hl=en Hope that helps. Good Luck!🍀

Hello @cathymathas9805 To generate a random name using the RANDBETWEEN formula, follow these steps. First, use the RANDBETWEEN formula to obtain a random integer between the specified numbers in column A (A2:A). If you want to keep the list dynamic, you may need to add a COUNTA function to define the last row. However, if you want to retrieve an actual name as a result, you need to wrap this function in the INDEX formula. The INDEX function allows you to retrieve the value of a specified cell, which we found using the RANDBETWEEN formula. And if you also want to include additional information, such as an email address, phone number, or other data for the randomly selected name, you can use the VLOOKUP function. Here is the final formula you can use to generate a random name: =INDEX(A2:A, RANDBETWEEN(1, COUNTA(A2:A))) All these concepts are intermediate level and just take a little practice. Testing it out a few times will make everything clearer with time. Cheers, & good luck! 🍀

Thank you very much, now it's clear. Thanks once again

@@cathymathias9805 You are very welcome ;-)