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"...
- Ohhh ok, I'm liking where this is going, how would I incorporate this into my sheet? would this be a second "sheet" and run my index off that second sheet? Or would I be able to include this into my original formula?
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!
