Filter values in a column which are not in another column

Note: This post was originally published in our community forum.

Hey everyone! 👋 Check out this handy formula for filtering values from one column that aren’t present in another column.

Here’s the formula:

This formula works by filtering data in the Submissions column that doesn’t appear in the Status column. The UNIQUE function ensures that only unique values are returned.

If you’re dealing with spreadsheet data and need to identify differences between two columns, give this formula a try!

Feel free to discuss or share your own approaches below. I am also sharing the 📊💬 Original Stack Overflow post