Excel Tricks with Tejraj

To explain “Date Filter“ in detail, we have a dummy data of some electronics products sold in 04 regions East, West, South and North from 1st Jan 2019 to 31st Dec 2021. Date filter can only be applied for the column which contains Date values. In our case we can apply Date filter for the Date column. Click on the drop down button which is available on header cell “Date” and click on “Date Filters” option as highlighted in below image. We can filter data available in this Date column based on below criteria’s: So let us now see each of the criteria in detail.  Please make a note that we will consider today’s date as “13th September 2020” throughout this post. So all the output results shown in this blog post will depend on this date. Equals:  This option will help us to filter the dates exactly equal to our input date. For example if we want to filter the data for date 1-Jan-20 then we will provide our “equals” criteria as shown in below image. This will provide us the output a...

In our previous posts we have seen about filters . In case you missed to read about what are filters and how to apply filter then click here to read in detail. In this blog post we will learn how to apply “Number Filters” in excel. We will see all the sub types of Number Filters in detail with below example. For this we have taken a data of some electronic products sold in East, West, South and North regions from 1st Aug 2019 to 1st Apr 2021 with us. Number filters can be applied to column which contain number values. So in our case we can apply number filters to column “No of Items Sold”. Click on drop down button which you will find on header cell “No of Items Sold” and you will see the “Number Filters” option as highlighted in below image. We can now filter the data present in this column based on below criteria’s: Equal Does Not Equal Greater Than Greater Than Or Equal To Less Than Less Than Or Equal To Between Top 10 Above Average Below Average Custom Filter Now, we will explai...