Random Selection from a List in Excel & Google Sheets

Random Selection from a List in Excel & Google Sheets.
#excel #googlesheets #random

[@PrettySkies]

=INDEX(A1:A10,RANDBETWEEN(1, COUNTA(A1:A10))) Thanks!

[@Wasaia]

I keep trying this, but I keep getting errors. I triple-checked everything... Can't seem to find what I'm doing wrong.

[@Wasaia]

I found the problem! It seems in my case I have to use ; and not , Something to do with language settings. Very confusing

[@netboy1102]

Great, just used this random between function few days ago for a qrcode order system. All the stuff used were from your tutorials. Best teacher.

[@ExcelGoogleSheets]

Great to hear!

[@j0llyr0gerer]

Excellent video thankyou!

[@hectorrojo]

Thank you!, super useful formula

[@joemanco69]

Thanks Really Helpful!

[@ad_astra_crimson]

is it possible to get multiple samples from the same name? like i can specify how many samples i need

[@samjones677]

Is there anything you can change about the formula that makes it not pick the same item as the previous attempt?

[@mateusz.ptaszek]

You can add a checkbox next to in and every time you click it it will randomise.

[@ExcelGoogleSheets]

👍

[@tomolaureys]

Is there a way you can lock a selection? I took the if formula combined with it but for each row I would like the system to not update the already filled in cells. =if(regexmatch(F12,"Growth"),Index('Input x'!$A$2:$A$3,RANDBETWEEN(1,Counta('Input x'!$A$2,'Input x'!$A$3))))

[@tahirshah6979]

what if I want two names at the same randomly? or with replacement and without replacement.

[@Zman0]

Excellent video!!

[@sonurathi2055]

Is it possible to select 10% of the items from the list randomly.

[@sergheyzaporojanu6872]

great tutorial. used it at work for asignmet prioritisation. Now I wonder if there is a way to check if value already exists in the same column to make the following randoms not repeating. or repeating but a controllable number of times. I really appreciate all kinds of ideas.

[@ExcelGoogleSheets]

kzbin.info/www/bejne/aqC8d4uvhr1_jtk

[@droven101]

Indirect(A&*your rand function*) also works

[@ExcelGoogleSheets]

You probably mean Indirect("A"&*your rand function*) The issue with this is if you add columns or rows before the range it will not adjust the A or row position.

[@jenniferkruger8316]

Can you index to sheet2?

[@lpanebr]

One way to do manual calculations in Google sheets is to set calculations to update on open. Then you can refresh. But this is far from the ideal manual Excel calculation.

[@lpanebr]

Hmm.. now that I wrote this I wonder apps script allows us to change the calculation mode. If it does maybe we could create a checkbox that sets it to reload when unchecked and to automatic when checked..

[@ExcelGoogleSheets]

Not sure if you have different options than I do. My options are; on change, every minute, every hour. I don't have on open option.

[@ExcelGoogleSheets]

If you gonna do a script, it might be just easier to just generate the random number using the script // Returns a random integer from 0 to 9: const randomNumber = Math.floor(Math.random() * 10);

[@lpanebr]

@@ExcelGoogleSheets you're right! I wrote from memory.

[@netboy1102]

@@lpanebr maybe use on edit or on change to trigger the Setformula into that sell. Use if statement to check the value of the checkbox?