FILTER Data Automatically in Excel, with and without Dynamic Arrays | Excel Automation - L0012

Опубликовано: 02 Январь 2025
на канале: Celia Alves - Solve & Excel

2,051

When you need to find the entries in your data that match certain criteria, how do you do it? Table filters are one option, but they can be cumbersome to manage. There are other tricks that we can use. I will share two options in this class.

NOTE: Between min 47:00 and 59:00 you will see me struggling with Advanced Filter not producing the expected results. It was due to, by mistake, having entered criteria "Mary" under the field client, instead of the field "Sales Rep." More details about Advanced Filter, including automation, will come in the next class.

Get access to the exercise files by joining our Telegram Group at https://t.me/celiaalvessolveexcel
Subscribe to my Newsletter for exciting news about the Excel world: https://bit.ly/learnfromcelia
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn: / celiajordaoalves
Facebook: / solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel