Random Selection from a List in Excel & Google Sheets

No video

Random Selection from a List in Excel & Google Sheets

Рет қаралды 15,248

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

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

Пікірлер: 28

@PrettySkies Жыл бұрын

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

@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!

@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

@j0llyr0gerer 7 ай бұрын

Excellent video thankyou!

@hectorrojo 6 ай бұрын

Thank you!, super useful formula

@joemanco69 8 ай бұрын

Thanks Really Helpful!

@Zman0 Жыл бұрын

Excellent video!!

@mateusz.ptaszek 2 жыл бұрын

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

@ExcelGoogleSheets 2 жыл бұрын

👍

@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 Жыл бұрын

kzfaq.info/get/bejne/atWJebuqtr6wiKs.html

@ad_astra_crimson 10 ай бұрын

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?

@tahirshah6979 Жыл бұрын

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

@sonurathi2055 Жыл бұрын

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

@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))))

@jenniferkruger8316 Жыл бұрын

Can you index to sheet2?

@droven101 2 жыл бұрын

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

@ExcelGoogleSheets 2 жыл бұрын

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.

@lpanebr 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

@@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?