Advanced Filters

[Gaetano_B]

Hello lovely people, 

I'm trying to get in column A the following output: 

Milestone: 0. Completion should NOT include: "10. KYC Complete" and "2. Pending Descope / Exit",  "2. Descope Confirmation" from col. B

1. QC Submission should NOT include: "10.", "2.", "8." and "9" from col. B

2. Business Connection should ONLY include statuses "0." and "3." from col. B

Would you be so kind to help?

Thanks, 

Gaetano

[MarqueeCrew]

@Gaetano_B ,

 from my iPhone it looks like there is a space after each decimal point.  

IMO the best way is:

left([col b],3) Not in ("10.", "2. ", "8. ", "9. ")

....

 I'll let you figure out the next expression. 

cheers,

 mark

[Amarendra · Accepted solution]

You can use a formula tool for your conditions and then filter based on the output. PFA,