Forum Discussion
Help with random generator based on another cell.
Another approach would be to use FILTER to create a second list of the movies, specifically all those where the date column is blank. Then run your random numbers against that derived list.
The function would look something like this: =FILTER("ListOfMoves","Dates"="") Just substitute the appropriate references for the "ListOfMovies" and "Dates"...
Another approach would be to use FILTER to create a second list of the movies, specifically all those where the date column is blank. Then run your random numbers against that derived list.
The function would look something like this: =FILTER("ListOfMoves","Dates"="") Just substitute the appropriate references for the "ListOfMovies" and "Dates"...
I've attached a sample file in Excel. I think the same can be done in Google Sheets. (I"ve verified that the FILTER function works there, so syntax is probably very much the same if not identical)
In this sample, I just kept the filtered list adjacent to the longer original list. It could be a separate sheet in the same workbook, but needn't be. And you can run your random -- I didn't do that -- in column E. Then just enter the date (or just enter anything: "watched" "we loved this" "let's watch again") under "Viewed"
The sheet is attached; here's an image with the formula off to the right.
- I wonder if I'm allowed to post another question on here. If not, I'll make another post, but I just realized that the value shown on my "random" generator, is different for mine and her computer. If we both are viewing the sheet, we see different values. Any ideas off the top of your head? Thank you again!
This forum is only for Excel questions; to the extent your question has to do with pre-marital relationship counseling.....
Well, OK, here's an idea: You could take turns being the randomizer and work on trusting that the other has, you know, really gone with the computer rather than picking the one he/she really wants to watch. 😉
- I just tried it out! I created another column next to the Movie list, created the filter, used my random (index) and selected the filtered list, and then hid the column. IT WORKS!. This is exactly what I need!. Thank you SO much for you help!