Awesome video and information! I was able to create an auto meal planner for each day of the week using these formulas :)
@akistepinska Жыл бұрын
That is such a great use for this function @irmareyes9805! Thank you for sharing ( ^◡^)っ
@patrickburr30592 ай бұрын
This is literally what I'm trying to do. Now i need to figure out how to keep it from repeating selections.
@BubbleStarBlaster9 күн бұрын
Appreciate the detailed formulas!. Is there away to generate the random info with a button? A clickable call-to-action, that cycles through and provides a refresh, display newly selected data from your set?
@Stencilpirate Жыл бұрын
Great video! I was able to follow it al lthe way, is there a way to trigger the pick function without needing to edit the sheet? like a button needing to be clicked or something
@akistepinska Жыл бұрын
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!
@littlebill423 ай бұрын
Hi! Just wondering, what are you pressing to get the absolute value?
@akistepinska3 ай бұрын
To create an absolute reference in you need to press the F4 key after selecting or typing a cell reference. This works on both Mac and PC: On a PC: Simply press F4 after typing a cell reference to toggle between relative, absolute, and mixed references. On a Mac: Press Command (⌘) + T if the F4 key doesn't work directly. If your Mac has a standard function key layout (F1, F2, etc.), F4 should work similarly to a PC or press Fn key + F4 Here are all the shortcuts: support.google.com/docs/answer/181110
@matacra7 ай бұрын
are the formulas always different to one another? or just doesnt matter cuz its a big sample size? im doing this with 4 cells, i want them to not repeat, i dont know how to make it work the way i wanted, anyways great video, really helped me even if its not exactly the way i want
@pincer28857 ай бұрын
is there a way to make it so that the randomizer only changes when you click a button or change a cell?
@akistepinska7 ай бұрын
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🍀
@zackyep6 ай бұрын
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]))))
@TheQuizzyMind7 ай бұрын
Very good tutorial. Solved my problems 👏👏🙂🙂
@akistepinska7 ай бұрын
Thank you so much @TheQuizzyMind!. 🍀
@AnnaJefferies-o7n9 ай бұрын
Is there a way to ensure that each name is used in the randomized list once? I am using short lists of 10-12 words and find that when randomizing, the list is doubling up on some words and not including others.
@akistepinska9 ай бұрын
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🍀
@cameronparry5623 ай бұрын
Enjoyed this - thank you
@akistepinska3 ай бұрын
so glad it was helpful!🍀
@dakotahedwards1670 Жыл бұрын
How can you keep track of the winners?
@akistepinska Жыл бұрын
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!🍀
@cathymathias9805 Жыл бұрын
it's hard to understand, too much information at once. you have to be specific. I couldn't get anything at all
@akistepinska Жыл бұрын
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! 🍀
@cathymathias9805 Жыл бұрын
Thank you very much, now it's clear. Thanks once again