How to Index & sort values using the helper column in Excel.

In this article, we will learn How to Index & sort values using the helper column in Excel. Scenario: Sometimes working with unmannerly ...

How to Sort in Ascending and Descending Order While Using Auto Filter in Microsoft Excel

In this article, we will learn how to sort in Excel. Sorting is any process of arranging items systematically in Microsoft Excel and has two common, ...

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...

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 Youtube