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
@j0llyr0gerer7 ай бұрын
Excellent video thankyou!
@hectorrojo6 ай бұрын
Thank you!, super useful formula
@joemanco698 ай бұрын
Thanks Really Helpful!
@Zman0 Жыл бұрын
Excellent video!!
@mateusz.ptaszek2 жыл бұрын
You can add a checkbox next to in and every time you click it it will randomise.
@ExcelGoogleSheets2 жыл бұрын
👍
@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_crimson10 ай бұрын
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?
@droven1012 жыл бұрын
Indirect(A&*your rand function*) also works
@ExcelGoogleSheets2 жыл бұрын
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.
@lpanebr2 жыл бұрын
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.
@lpanebr2 жыл бұрын
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..
@ExcelGoogleSheets2 жыл бұрын
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.
@ExcelGoogleSheets2 жыл бұрын
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);
@lpanebr2 жыл бұрын
@@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?