Advance Filters

Hi Garry

Thanks for getting in touch. This is a really unintuitive answer, and one area where the Advanced Filter could use a little help.

You are searching for an exact match, so you need to wrap the criteria in speech marks. You then also need to indicate that's the only thing you want. In the criteria cell you would type:

="=Sales"

With two equals signs and two speech marks as above.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector