How to filter in excel Archives

How To Search Multiple Items in Excel Filter

Oct 31, 2021 Excel Basics

One of the more common tasks in Excel is filtering data. Probably in every aspect of your Excel use you are using the filter, filtering can be done ...

How to use VBA DIR function in Excel (7 Examples)

Oct 31, 2021 Excel Functions

Excel provides several VBA functions that can be used while writing a macro or to define your own function to perform your desired tasks. In this ...

How to Filter Cells with Formulas in Excel (2 Ways)

Oct 31, 2021 Excel Formulas

In Microsoft Excel, there are not too many ways to filter cells that contain formulas. From the 2013 version of Excel, it has initiated a logical ...

How to Filter Multiple Columns in Excel Independently

Nov 15, 2021 Excel Basics

If your Excel worksheet contains a lot of data then it can be hectic to find information quickly. To facilitate this problem, the Filter of Excel can ...

How to Filter Multiple Columns in Excel Independently

How to Filter Multiple Columns Simultaneously in Excel (3 Ways)

Oct 31, 2021 Excel Basics

Filtering data is a great way to find information quickly especially when the worksheet contains a lot of input. When you filter a column then the ...

How to Apply Multiple Filters in Excel [Methods + VBA]

Nov 1, 2021 Excel Basics

Filtering becomes indispensable when you have a larger and complicated dataset. Retrieving the desired data is quite time-consuming from such a ...

How to Filter Multiple Rows in Excel (11 Suitable Approaches)

Nov 18, 2021 Excel Formulas

In our practical scenario with Microsoft Excel, we have to filter columns as well as rows from a large range of data for analysis. In this article, ...

Filter Multiple Criteria in Excel (4 Suitable Ways)

Nov 1, 2021 Excel Formulas 1

Today I will be showing how you can filter out some data matching multiple criteria using the FILTER function of Excel. Before going to the main ...

How to Filter Data in Excel using Formula

Nov 1, 2021 Excel Formulas

To filter data in Excel is quite usual, often you need to filter data to find the sets of data you require to operate a particular operation. Today ...

Excel Filter Data Based on Cell Value (6 Efficient Ways)

Nov 1, 2021 Excel Formulas

Sometimes data in a worksheet is too complicated or crammed that we face difficulties to find out desired data. Retrieve data from a dataset ...