About 1,012,929 results (4,843 milliseconds)

Sheets: Randomizing different rows - Google Docs Editors Community

https://support.google.com/docs/thread/108234070/sheets-randomizing-different-rows?hl=en
May 1, 2021 ... I would like to randomize all the blue rows while keeping the white rows directly under them during the shuffle.

Add randomize button to sheet - Google Docs Editors Community

https://support.google.com/docs/thread/271645744/add-randomize-button-to-sheet?hl=en
Apr 27, 2024 ... Is there any way to do this is Sheets or is this button exclusive to Excel? ... rows of data or the end result. I have a fully functional ...

randomize entries from a list, but exclude items when a checkbox is ...

https://support.google.com/docs/thread/93746763/randomize-entries-from-a-list-but-exclude-items-when-a-checkbox-is-checked?hl=en
Jan 16, 2021 ... On the Maps page , there is a checkbox in cell B5, that when checked, conditionally formats the rows that have an X in that column. This is ...

Trialhandler - Importing Conditions from Excel file

https://groups.google.com/g/psychopy-users/c/KxxG8L-5r6Q
My Psychopy version is v1.76.00 and currently I am trying to use only the builder to create an experiment where I can randomize the presentation of the stimuli ...

blank cells in Excel (self-paced reading)

https://groups.google.com/g/psychopy-users/c/EQsBV31cMg4
I would like to know if it is possible to go around blank cell in Excel and/or if there is a way to randomize stimuli of different groups (routines inside loops) ...

How to avoid presenting targets consecutively

https://groups.google.com/g/e-prime/c/jmWVb491tVk
Jul 16, 2011 ... ... Excel forumulas or macros or a Perl script or whatever to do that ... * the Target procedure would have a List2 with two rows and one added column ...

Array formula running count of a value based on order it was added ...

https://support.google.com/docs/thread/76011099/array-formula-running-count-of-a-value-based-on-order-it-was-added-so-sorting-doesn-t-mess-it-up?hl=en
Oct 9, 2020 ... If you sort my sample spreadsheet by the randomize column the cells that change the item number will be highlighted in red. Please any help ...

Randomizing within a single routine

https://groups.google.com/g/psychopy-users/c/yM8ZIGQoPUo
I have followed your explanation about how to use the excel file to add pictures as a stimuli. ... Entire rows are selected randomly, so your pairs stay ...

I am using google sheets and there seems to be a random break ...

https://support.google.com/docs/thread/66063986/i-am-using-google-sheets-and-there-seems-to-be-a-random-break-the-green-line-in-my-table?hl=en
Aug 20, 2020 ... I have also tried to delete rows bordering that break but the break just moved up. Hope the image helps, the green line in the middle is the ...

Randomizing a set of data - Google Docs Editors Community

https://support.google.com/docs/thread/14204706/randomizing-a-set-of-data?hl=en
Sep 12, 2019 ... i want to keep the rows and columns format. And also the list might be uneven (column a and b with 10 entries but column c with 8) and i ...

Shuffle Order of Responses in Google Forms? - Google Docs ...

https://support.google.com/docs/thread/45331314/shuffle-order-of-responses-in-google-forms?hl=en
May 8, 2020 ... I'd like Google Forms to shuffle or randomize the order of responses rather than displaying them in the order that those responses were ...

Class Range | Apps Script | Google for Developers

https://developers.google.com/apps-script/reference/spreadsheet/range
Creates an object that can protect the range from being edited except by users who have permission. randomize(), Range ... getRange('1:30'); // Applies row ...

Randomization

https://groups.google.com/g/formr/c/JAW5I31aYqc/m/FNpqP-KsCgAJ
I am randomizing blocks of ordered items in a survey and have two issues/questions: ... excel spreadsheet as (for example): 2B, 1C, 1A, 2A, 1B. Is this something ...

How do I stop randomizer from changing - Google Docs Editors ...

https://support.google.com/docs/thread/202388069/how-do-i-stop-randomizer-from-changing?hl=en
Feb 17, 2023 ... I created a sheet which fills in about 20 lines with random text from another sheet. Now every time I open the file it randomizes it again.

randomizing blocks?

https://groups.google.com/g/psychopy-users/c/e5b_Lddu4G0
Feb 7, 2011 ... ... row. So, every routine has a code component where ... Block is a condition in my BlockOrder file that references 1 of 4 other excel files.

How do I generate a random number but also keep it from ...

https://support.google.com/docs/thread/105268675/how-do-i-generate-a-random-number-but-also-keep-it-from-continuing-to-randomize?hl=en
Apr 6, 2021 ... I would like it to randomize once and then stick. I have tried a few different things but none seem to work great. Thanks! Details. Sheets, ...

"protected sheets and ranges" not showing up as an option under ...

https://support.google.com/docs/thread/102247799/protected-sheets-and-ranges-not-showing-up-as-an-option-under-data-in-my-google-sheet?hl=en
Mar 14, 2021 ... We have created a google-sheet which has cells formatted, some merged, some rows/colums frozen. ... You're editing an Excel doc! Yes? No ...

Can Psychopy randomly select a certain number of stimuli to display?

https://groups.google.com/g/psychopy-users/c/31yUKVdeNSc
Mar 13, 2014 ... I currently have an Excel spreadsheet with 3 columns "StimFile ... shuffle(conditions) #randomize their order. conditions = conditions[0 ...

Button to Randomize list of names - Google Docs Editors Community

https://support.google.com/docs/thread/214717024/button-to-randomize-list-of-names?hl=en
May 8, 2023 ... 2. Clear the range L3:L9 · 4. Enter this formula in L3: · =LAMBDA(x,IF(L1,x,x))(SORT(M3:M9,RANDARRAY(ROWS(M3:M9)),)) · Now you can tick/untick the ...