How to do this?

[PushX7]

Hello, so basically what I'm trying to achiveve, I barely have knowledge in Excel, but It'll make my life much easier.

https://i.imgur.com/eu5vWgS.png

So at the moment, there's a reason if it's blacklisted or not, the email, so if it's clean it'll just type clean.


So what I'm trying to grab is, if an email from a sender has been CLEAN and BLACKLISTED/VIRUS/ANYTHING ELSE OTHER THAN CLEAN it'll display a list of the emails that got BLACKLISTED AND clean.

REASON: Sometimes an email passes through, so we want to know if the email was clean before then turned blacklisted once we updated the system.

 

[xyga1998]

Please explain better as I can't understand what do you want to achieve. Example: "I want to display a list which is clean and paste it to another sheet" or if you want to remove all except clean etc...
If you just want to display the list you can easy accomplish it with FILTER

So what I'm trying to grab is, if an email from a sender has been CLEAN and BLACKLISTED/VIRUS/ANYTHING ELSE OTHER THAN CLEAN it'll display a list of the emails that got BLACKLISTED AND clean.

 

[PushX7]

Yeah sorry, I was rushing when i typed that.
So basically, there's a list of emails that are being sent and who recives it.
So sometimes emails dont pass so they're marked with several other things.
If an email is passed it'll be clean.
So sometimes the email gateway doesnt notice viruses or anything.. until an update.
So emails get passed..
We want a list of emails that are "CLEAN" AND ANY OTHER CATEGORIES.

So the formula i want.. needs to grab test@test.com since it was CLEAN before and then turned to BLACKLIST.

but good@good.com shouldn't show, because its just blacklisted it never got cleaned.

 

[PushX7]

Bump anybody?

 

[PushX7]

Ill pay if its needed, i just need a formula or something to filter.