Filter on two values

[BrettFL]

I'm trying to create a filter that would keep all rows except when:

Column B [Portfolio] = Information Technology and column D [Configuration Item] is empty.

Column B [Portfolio] = Mercury and Column D [Configuration Item] is empty.

If Information Technology or Mercury have configuration items then they should not be removed.

Appreciate any help!

[pedrodrfaria · Accepted solution]

HI @BrettFL 

Is this what you are looking for?

[Portfolio] = 'US Information Technology' and !IsNull([Configuration item]) or
[Portfolio] = 'Mercury' and !IsNull([Configuration item])

Pedro.

[BrettFL]

Spoiler

Thank you, perfect!