Advanced Filter in Excel allows you to use complex criteria to extract records and place them in another location without affecting the main dataset.

In this video, we extracted Unique records, displayed records with containing specific words; filtering with the logic Functions "OR," "AND"; we also extracted values within specified ranges using "Between."
Practice makes perfect. We have included the practice file so you can practice and become perfect in Advanced Filter.

Download the Advanced Filter Practice file here:
[ Ссылка ]

If you like the video, please subscribe and share with others.
Havron is bridging the skills gaps.

свернуть