How to create advanced and dynamic filters in Excel step by step

Who I am
Pavel Yosifovich
@pavelyosifovich
Author and references

But this time we will talk about advanced filters and how useful they are when using them. Here because we will explain step by step how to create advanced and dynamic filters in Excel.

But what is an advanced filter? Through this filter we can pass data that is in another place in the known spreadsheet and even in another spreadsheet. The data we request will pass through this filter and provide us with the specific information we want. So in this way we will only receive the requested information.



Microsoft Excel functions and formats are sometimes a bit complicated because you need to include some formulas in the text box or a special command. And although it may seem difficult to do this, it is actually very simple to do, if you follow the steps that we will present in this tutorial. Next we will teach you how to create advanced and dynamic filters in Excel step by step.

How to create advanced and dynamic filters in Excel step by step

So that you can create advanced and dynamic filters in Excel step by step, we will show you what you should do. Remember that when you create a filter, you will take part of the information contained in a very large database. And you will pass them to another Exel sheet, but only the information you need.

To do this we will go to our spreadsheet and open the one where we have all the information. Then we will open a new spreadsheet, in it we will enter the name of Filter. In our data table we have a column called Names and there are 25 different data in it.


In the next column labeled Product with 25 different data and a third column with the name of Profit. So the filter we want to do is on the sales that any seller has made. So the filter we will use is the Name and in order to activate this filter, we will go to the main menu options.


This is at the top and we will select the Data tab, then we will create a clip in Group Order and finally Advanced Filter. Once this action is done, a box will appear in which you need to enter some data. In it you have to choose the Copy to another place option and now you have to write the Rank of the list.

How to fill in the advanced filter box

In our case we will position $ B $ 6: $ D $ 31 with this we will select all the ranges of our table. In the Criteria range option we enter F8: H9 and in Copy to we have to write the filter ¡$ F $ 12. And finally we have to create a clip on the Accept option, once done, the advanced filter will start to act and the data will start to be copied.


As you can see, using this advanced filter feature will help you avoid having to rewrite the data you already have in a table. It will also allow you through this formula to avoid having to waste time looking. You just have to try to enter the data correctly so that it doesn't throw you an error message.


And in this very simple way you learned what the advanced filter function is for and how to use it. As always we give you practical tools to teach you and you can learn in this case how to create advanced and dynamic filters in Excel step by step.


add a comment of How to create advanced and dynamic filters in Excel step by step
Comment sent successfully! We will review it in the next few hours.