It shouldn't be that hard - 3xbegins with filter

Hello all!

So all I want do is 3 'begins with' filters but excel only offers me 2 inthe filter. I appreciate I can do the two save them to a sheet and then go back for the other but that defeats the object. Any help would be most welcome....

I would suggest adding a "helper column" and using this formula and then sort. Copy the formula in the entire column

=IF(OR(LEFT(F3,3)="XXX",LEFT(F3,3)="YYY",LEFT(F3,3)="ZZZ"),F3,"no match")

Here's a quick breakdown:

F3 - represents the cell that you want to sort by.
3 - is the number of characters from the left you want to search for.
"XXX" "YYY" "ZZZ": the beginning 3 characters.

The formula will return the full contents of the cell you selected and will return "no match" if it false. You can change what you want returned if true by replacing "F3" after the ZZZ in the formula.

Hope this helps!

Advanced Filter will accept any number of conditions.

Problem solved - I thank you - I'll buy the beers