Advanced Filter

[AECOMC]

Hi,

I'm filtering a set of data, and they all contain a similar identification such as "1A1P01" or "2XDP67", the common denominator in each name is the letter P.

However when I filter "???P??" it comes up with anything containing the letter P not just IDs with the that specific amount of letters.

I hope that makes any sense and you can help me!

Thanks.

 

[AECOMC]

Re: Advanced Filter Help

Yes sorry! I was trying to keep it simple at the start!

No it isn't the pier numbers are the "1A1PO1" style numbers.

 

[Gerald Higgins]

Re: Advanced Filter Help

Sorry, I can't come up with a set of filter conditions that can do this.

Maybe someone else can.
Or maybe you could do it with helper columns.