excel filter - Free Excel Tutorial

Filter or Remove Columns

Assume that in MS Excel, you have a table consisting of a few columns consisting of few values, and you want to filter to remove the specified columns from the table. You might take it easy and would prefer to manually filter out to remove the desired columns from the table, without any need for… read more »

Filter with Multiple Criteria

If you are an valid MS Excel user, you have probably come across a situation where you wanted to filter the data in a separate table with complex criteria. You could do this task manually, which is also acceptable while dealing with a few data items. But if you got a task to filter out… read more »

Filter with Exact Match(Case-Sensitive)

Suppose that you have a table consisting of a few cells with few values, and you want to filter out the set of records with the exact match concerning case sensitivity. You might take it easy and would prefer to manually filter out the desired case-sensitive match into another table without any need for the… read more »

Filter or Extract for Multiple OR Criteria

If you are an valid MS Excel user, you have probably come across a situation where you wanted to filter the data in a separate table with specific criteria. You could do this task manually, which is also acceptable when dealing with a few data items. But if you got an assignment to filter out… read more »

Filter or Extract with a Partial Match

Assume you have a table consisting of a few cells having few values, and you want to filter out the set of records with the partial match. You might take it easy and would prefer to manually filter out the desired partial matching values into another table without any need for the formula; then congratulations… read more »

Filter Multiple Values

In Excel, you can easily filter a table to display only the rows that meet your criteria. This is a quick way to find the information you need without scrolling through all the data. In this post, we’ll show you how to do it. Then, we’ll show you some other ways to filter data in… read more »

Filter Data between Date Values

This post will guide you how to filter data between two given date values using FILTER function in Microsoft Excel. The General Formula is as follow: =FILTER(total_data,(date_range>=start_date)*( date_range <= end_date),”Not Found”) Summary: You can filter data to include only records between two dates with the FILTER function. For example, E4 uses this logic: =FILTER(A2:C9,(B2:B9>=E2)*(B2:B9<=F2),” Not… read more »

Filter Data By Date Field

The use of Microsoft Excel’s Format Cells and Auto Filter option is a great way to filter data by year or Month. This article will discuss how to filter by date field using Filter function and Format cells in Microsoft excel. Filter Data by Date Field using FILTER Function The General Formula is as below:… read more »

Extract or Filter Every Nth Row

Assume that you’re in a situation where you need to filter every nth row from a list having a few values. I’m pretty sure you’d choose to do it manually, which is also a great choice when you only have a few values in a list and want to filter out every nth row. However,… read more »

Extract or Filter exclude blank values

Let’s suppose that you have assigned a task in which you need to filter out the values by excluding the blank values from the list having few values, and I am also pretty sure about it that you would definitely choose to do it manually, which is also a great choice when you have only… read more »

Extract or Filter Horizontal Data

You might have been through this kind of situation where you need to filter out the horizontal data from the list having few columns. I am also pretty sure about it that you might have chosen to do it manually, which is also a great choice when you have only a few values in a… read more »

Extract or Filter on The Top N Values with Criteria

Suppose that you are in a situation where you need to filter out the top n values from the list having few values with specific criteria, or you can say that with a particular condition, and I am also pretty sure about it that you would definitely choose to do it manually, which is also… read more »

Extract or Filter Top n values

You might have been through this kind of situation where you need to filter out the top n values from the list having few values, and I am also pretty sure about it that you might have chosen to do it manually, which is also a great choice when you have only a few values… read more »

Extract matching values From Two Lists

Suppose that you are working with two lists containing few values, and you want to extract the matching values from those two lists into another separate list. You might prefer to manually extract the matching values from the two lists, which is ok for the few values, but it would be a big deal to… read more »

Extract Common Values in Two Lists

Just assume that you have two lists containing values/words in the few cells, and you want to extract the same or common values/words from the two lists into another separate list; then you might think that it’s not a big deal; because you would prefer to manually extract the same or common values/words from the… read more »

Filter Data by Column and Sort by Row

This post will guide you how to use the FILTER function to filter a value by column and then sort data by row in Microsoft Excel. You can use the following formula based on the SORT function in combination with the FILTER function to filter data by column and the sort data by row in… read more »

Filter And Transpose Data From Horizontal To Vertical

This post will show you how to use Filter function and in combination with Transpose function to filter data from horizontal and transpose data as vertical in Microsoft Excel. You can refer to the below general formula based on TRANSPOSE and FILTER function: =TRANSPOSE(FILTER(range,logic)) You can use the FILTER with TRANSPOSE function to filter data… read more »

How to Hide Rows Based on a Cell Value in Excel

This post will guide you how to hide rows based on cell value in Excel. How do I hide rows based on cell value with VBA Macro code in Excel 2013/2016. Hide Rows Based on Cell Value using Filter Feature Hide Rows Based on Cell Value using VBA Macro Hide Rows Based on Cell Value… read more »

Sidebar