How to Use Advance Filter Option in Ms Excel in Hindi | Excel Tutorial- BPA Educators

Excel Advanced Filter – as the name suggests – is the advanced version of the regular filter. You can use this when you need to use more complex criteria to filter your data set. Advanced Filter in Excel to create a list of unique items, or to extract specific items to a different worksheet. You can also use complex criteria with an Advanced Filter, so it is useful when a simple AutoFilter can’t do what you need.

#excel #autofilter #exceltips #exceluse #howtouseexcel #bpaeducators #bpa

Here are the steps for setting up your data, and creating an Advanced Filter. — Set up the database — Set up the Criteria Range (optional) — Set up the Extract Range (optional) — Apply the Excel Advanced Filter