Filtering by the Date Field in Microsoft Excel

If you have a range of date, and if you want to filter the data as per year or month, you can do it by using the Format Cells and Auto filter option i...

Shortcut to open drop down filter in Excel

In this article, we will learn the shortcut to open a filter drop-down list and the filter in Ribbon in Microsoft Excel. “Auto Filter” option all...

How to Save Filter Criteria in Microsoft Excel

To save the criteria while filtering data,, you need to use Custom View in Microsoft Excel. What is Custom View? This tool is used to save the curre...

Count unique items using Advanced Filtering

Whilst using Excel there will be a good number of scenarios where you want to find the number of unique values you have in a range of cells.  this co...

Filter by selected cell

D you knnow that you can filter the data as per the selected cell on Excel spreadsheet. Excel 2007 onwards versions has this feature. You can filte...

Saving Filtering Criteria in Excel 2007

To save filtering criteria, use Custom Views: 1. Filter a List. 2. Select Page layout -> Custom Views (in Sheet Options Group) -> Add. 3. I...

Filtering by More Than Two Criteria in Excel 2007

To filter a List using more than one criteria, use the Advanced Filter: 1. Insert three new rows above the List. 2. Copy the heading row List, and...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube