IFERROR Function

How to Use INDEX MATCH with Multiple Criteria for Date Range

Variables (such as commodity price, share, interest rate, etc.) subject to dates cause general people to panic, as their prices depend on dates. ...

Create Excel Filter Using Drop-Down List Based on Cell Value

A drop-down list filter is basically a list of unique names. If you select any of the items from the drop-down list, you will get the corresponding ...

Excel Data Validation Drop Down List with Filter (2 Examples)

In this article, I will discuss how you can filter excel data using a Data Validation drop-down list. Usually, in Microsoft Excel, we use the Filter ...

How to Find and Replace Using Formula in Excel (4 Examples)

This article will help you to understand the find and replace formula(s) in Excel. Sometimes we need to edit our data in Excel sheets and for that ...

How to Find and Replace Multiple Words at Once in Excel (7 Methods)

Often we need to replace values. In this article, we've shown you 7 methods to find and replace multiple words at once in Excel. A company previously ...

Compare Two Cells in Excel and Return TRUE or FALSE (5 Quick Ways)

While working in Microsoft Excel, often we need to compare two cells in excel. This is a basic operation we do in excel and luckily, excel has ...

Creating a Drop Down Filter to Extract Data Based on Selection in Excel

The Filter feature in Excel helps us to extract data according to our selections. But the problem with the feature is that the row numbers and the ...

How to Combine Rows from Multiple Sheets in Excel (4 Easy Methods)

In this tutorial, we will demonstrate different methods of how to combine rows from multiple sheets in excel. While working with multiple sheets in ...

How to Remove Blank Cells from a Range in Excel (9 Methods)

While working with a large range of datasets, we might see some unnecessary blank cells which are pretty annoying. Luckily, in excel, there are ...

How to Count Unique Values Based on Criteria in Another Column in Excel

If you are working on different categories of information in an Excel worksheet, you might need to find out and count all the unique values of the ...

How to Remove Blank Cells Using Formula in Excel (7 Methods)

Our dataset often has blank cells. We can remove blank cells in Excel by using more than one formula. We have a dataset of the employees of a ...

Count Unique Text Values with Criteria in Excel (5 Methods)

This article illustrates 5 methods on how to count unique text values with criteria in excel. You may need to extract customer names who appear ...

How to Compare Multiple Columns Using VLOOKUP in Excel (5 Methods)

Often, we have to work with multiple columns in Excel to search for the common data or to find out the missing values. On the other hand, the VLOOKUP ...

How to Convert Number to Text for VLOOKUP in Excel (2 Ways)

In Microsoft Excel, the VLOOKUP formula is one of the hottest topics that you can find on the internet. There are numerous articles on this topic ...

How to Skip Blank Rows Using Formula in Excel (8 Methods)

A Microsoft Excel spreadsheet with blank rows is a frequent occurrence. The majority of them are superfluous, and they take up extra space on the ...

ExcelDemy
Logo