I have my rather large vinyl collection entered into numbers. I used this INDEX(TABLE 1::F1:F2020,RANDBETWEEN(1,2020)) to create a random play generator. Now, I would like to take this a step further. I want to filter my library by year of release (which I can already do), and THEN generate a random selection from those filtered results. Is this possible?
As I am disabled, my music collection is the best way to help me deal with chronic pain. I often play titles from a specific year…such as 1971…to think about their 50 year anniversaries and what they mean to me.
I can already create a random selection from my entire Library, I want to learn how create a random selection from filtered results.