I have a data set of 3229 movies, and I need to create random sample of 200 movies released before 2010, and also between 2010 and 2019.
I started with the trying to do the ones for 2009 and below 2010. I managed to make it work for one cell but when I expand it down to 200 rows, the cells whose corresponding year is > 2010 instantly returns FALSE, not sure workaround for this since I'm already indexing through.
Right now I'm using this Formula:
=IF(C2:C3230 < 2010, INDEX(F2:F3230,RANDBETWEEN(1,3229)))
Where C is the column for the years
and F corresponds to the titles I want to print into my new sample.
Any help is much appreciated.
Please note, since I Couldn't find an upload button otherwise I would've upload the file also.
