Forum Discussion
Solved
Help with random generator based on another cell.
Ok, so this is going to be oddly specific, but please bear with me. I am using Google Sheets so that my gf can use this doc with me. Here's what we are trying to do. I am currently deployed overse...
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 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. 😉
- HA!. Yes, that's what we have been doing, there are times where I feel like it's somewhat improbable that her "random" generated movies are always the ones she put on our list...
Thanks again for your help! I really do appreciate it. It is exactly what I needed. I was definitely overthinking it.- Whereas I'm sure that when you run the random pick it always "just happens" that Rambo or Jason Bourne are the pick.
On Excel: one of the fun things about Excel is that there almost always two or three ways to accomplish a given task. It's a very versatile tool.