I have a large record collection and I want to pick a random record to play each day. I don’t want any duplicates till every one of them is played but that seems complicated. I can just delete the row after I play the record for ease of use. It’s about 2 years of record playing
collection-20220131-1005.ods (26.5 KB)
I am a real novice at spread sheets
Without getting into NIST-level randomization, just fill one column, say, to the left of your column of records down to row 1000 or so with random numbers. Now sort both columns at a time ascending based on the left column.
I’d recommend copying my original two columns first, to make sure I didn’t mess up my database of records, etc.
So, it’s:
-
Build a new column of random numbers just left of your record names. Insert the column if needed, then highlight from top to bottom beside all your records. Now go to Sheet>Fill Cells>Fill Random Number. Just accept the defaults and click OK for the dialog box.
-
Copy (if you want) these two columns…the random numbers and the record names, which should be side-by-side. Paste those onto a new sheet.
-
Now highlight both columns or their copies (actually, LO will probably recognize the columns as a sort range anyway), then select Data>Sort>Ascending. That will order the random numbers, but randomize the record names.
RandomOrder.ods (19.1 KB)
1 Like