I have two lists (unique sets) in a spreadsheet and I want to get the intersection of the two.
Is there an easy way to do this?
Here's an example of what I want to achieve: intersection of two sets
This little script will compare two ranges, as a formula:
In your sheet you can add in cell D2 the following formula :
Add the script via the tools menu, script editor.