Louisa has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Advanced filters
Hi,
I recently attended an advanced VBA course and Gary showed us how to get a list of the different values for a filter using an advanced filter.
Can I have some help as I don't seem to be able to do this at work.
Thanks
Louisa
RE: Advanced filters
Hi Louisa
Thanks for getting in touch. Great to hear from you.
The Advanced Filter is a curious one. As I explained at the time, the dialogue box doesn't explain it's options very well. I explain it over on our blog:
https://www.stl-training.co.uk/b/exceltraining/2013/02/how-to-display-unique-entries-in-an-excel-list/
Hope this helps - do let me know if you need more detail.
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
