Hi All,

First time poster, but I'm struggling with a problem that I could use your help on. I have a large data set, and I'm trying to isolate Unique Values, but based on data in two columns.

Here's what I mean:

I have two columns- Column A is event name, and Column B is email address.

My problem is this: I have duplicates in this sheet, but I also have many distinct events that have the same name but come from different email addresses. Is it possible to filter by unique values for column A as long as Column B is also distinct?

Cheers