In the following article we are going to talk about a very useful tool when carrying out our work using a spreadsheet. In this case we will talk about the renowned Microsoft Exel application, we have previously touched on important points about the application of its functions.
But this time we will talk about advanced filters and the great utility they have when using them. That is why we are going to explain how to make advanced and dynamic filters in Excel step by step.
But what is an advanced filter? Through this filter we can pass data that is in another place in the well-known spreadsheet and even in another spreadsheet. The data we require will go through this filter and give us the specific information we want. So in this way we will receive only the requested information.
Microsoft Excel functions and formats are sometimes a bit complicated because some formula needs to be included in the text box or special command. And although it may seem difficult to perform this operation, it is actually very simple to do, if you follow the steps that we are going to present to you in this tutorial. Next we are going to teach you how to make advanced and dynamic filters in Excel step by step.
How to make advanced and dynamic filters in Excel step by step
So that you can make advanced and dynamic filters in Excel step by step, we are going to show you what you should do. Remember that when you are going to perform a filter, you are going to take part of the information that is contained in a very large database. And you are going to pass them to another Excel sheet, but only the information you need.
To do this we are going to go to our spreadsheet and we are going to open the one where we have all the information. Then we are going to open a new spreadsheet, in it we are going to place the name of Filter. In our data table we have a column called Names and in it there are 25 different data.
In the next column called Product with 25 different data and a third column with the name of Profit. So the filter we want to perform is on the sales that any vendor has made. So the filter that we are going to use is the Name and so that we can activate this filter, we will go to the options of the main menu.
This is at the top and we are going to select the Data tab, then we click on Group sort and finally Filter Advanced. Once you have performed this action, a box will appear where you must enter some data. In it you must choose the option Copy to another place and now you must write the Range of the list.
How to fill the advanced filter box
In our case we are going to place $B$6:$D$31 with this we are going to select all the ranges of our table. In the Criteria range option we are going to place F8:H9 and in Copy to we must write filter ¡$F$12. And to finish we must click on the Accept option, once this is done, the advanced filter will begin to act and the data will begin to be copied.
As you can see, using this advanced filter function will help you avoid having to retype data that you already have in a table. It will also allow you through this formula to avoid having to waste time searching. You just have to try to enter the data correctly so that it does not throw you an error message.
And in this very simple way you have learned what it is for and how to use the advanced filter function. As always we give you practical tools to teach you and you can learn in this case how to make advanced and dynamic filters in Excel step by step.