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