Garry has attended:
Excel Introduction course
Excel Intermediate course
Advance Filters
When using the Advance filter, if you have three departments named Sales, Sales Support & HR. You want to see the results for the Sales department only, but when you select Sales you also get those for the Sales support department as well. How can you avoid this other department (which contains Sales within its name) ?
RE: 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
