Hi there, in my app, I have a sheet with movies. One of the columns is a user-specific “Like” column.
Now I’d like to filter the movie list to get only the intersection between what the current user liked, and what another user of the app liked.
- I liked “Jurassic Park”, “E.T” and “2001 Space Odyssey”
- The other user liked “Indiana Jones”, “Jurassic Park” and “Jaws”
- The app returns “Jurassic Park” only
Do you have any idea if and how this is achievable?