In Excel you can filter your data on one particular matter barometer check that every trick can be who
wrote the name Arthur Bill Price of like.
But on any other column that is available in your sheet.
So for example you can only think of the words which contain one particular word India.
Correct names for example make or you can go on for a price on a particular range for example between
2 and 3.
Or you can only go through which are recyclable.
Let me show you how we do it.
So let's go to our top panels and click on this page icon here now you will see that the drop on icons
have been put together on all the column headers.
If other click on this job not here you can see you can only reflect the products which are recyclable
Netflix.
Yes and click Okay so you are only seeing the products which are recyclable.
Let me show you some other photos as well.
So let's select all of these in this column to select on the DECA and let's go to through a crude retail
price.
When you click on this dropdown you can see select one particular item from this list.
But you can also click here on this number because and apply your papers in multiple different dimensions.
Let us choose between function for this particular example and others too.
The only records with the retail price is between 2 and 3.
So if you read this the outcome on is saying that only prior to the retail price as their correct is
greater than where the real price is greater than two and just then three click OK.
And you will see that only those records have been selected where the retail price is between 2 and
3 just dislike this filter.
And let me show you the bird name filter so you will click on the drop the icon and you can select any
one particular product you want.
For example I only want these two to be proof these folk works here and you will see only those records
have been presented on your screen.
Let me select all of you.
And let me show you that picture here.
You will click on the specs what it tells you and you can select equals begins with and that or something
else.
I will continue this year here and I will say only click bring those records were the correct names
and dance mode.
You will see that all of these records do contain milk in their name.
So this way you can apply filters and marked multiple different dimensions to choose only some products
which match a specific criteria.
So that is one beautiful feature available in excel where you can choose a particular type of data that
matches your name.