Hide results based on criteria in a column

User_I3A7A

A bit unsure the words for this one. I want to show the results from one column based on another column's contents, but only if a particular value appears in the column.

Column A has values 1, 2 and 3. Column B has values x and y. If value 1 has a row for x and another row for y, I want to show it. If value 1 has only x I want to hide it. So in my below example, I'd only want to show the rows where column A has values 1 and 3.

Column A - Column B

1 - x

1 - x

1 - y

2 - x

3 - y

3 - y

Sorry if this makes no sense, I honestly don't know how to word this

Gianni Ceresa

If value 1 has a row for x and another row for y, I want to show it. If value 1 has only x I want to hide it.

So why in the above example you say that you expect to see only rows where column A has values 1 and 3?

Value 3 doesn't have a row for "x", and therefore doesn't match your "show it" rule.

In what exact product (and version) you want to implement such kind of rule?