IFERROR function

Extract Data from Table Based on Multiple Criteria in Excel

In this lesson, I'll demonstrate 11 effective approaches so that you can use Excel to extract data from table based on multiple criteria including ...

VLOOKUP to Find Duplicates in Two Columns in Excel

If you have multiple columns and the columns contain duplicate values, this article will help you find those duplicates with ease. Today we will show ...

4 Quick Ways to Merge Rows with Same Value in Excel

Sometimes we need to merge rows with the same value in Excel. In this article, we are going to show you how to merge duplicate rows in Excel with 4 ...

3 Ways to Combine Duplicate Rows and Sum Values in Excel

Sometimes we need to combine duplicate rows and sum the values in Excel. In this article, we are going to show you how to combine duplicate rows and ...

Excel Formula: Use VLOOKUP Function with Multiple Sheets

The VLOOKUP function is basically used to search values vertically, and it’s a very easy and useful tool in Excel. This article will discuss how to ...

8 Ways to Create a Unique List Based on Criteria in Excel

Maybe you have a list of repeating data that you want to sort. In Excel, you can actually make a unique list based on criteria. However, this is only ...

3 Ways to Count Duplicate Values in Excel Only Once

Often in a dataset, we want to estimate duplicate values once to actually determine the different entries and their number. In a large dataset, ...

9 Unique Cases to Compare Rows for Duplicates in Excel

Users frequently need to locate or compare different rows to search for all the duplicates within them in Excel. It's quite straightforward and easy ...

7 Easy Ways to Populate List Based on Cell Value in Excel

In some cases, we need to populate list based on cell value in Excel. Like, suppose you have a dataset of sales of the previous year. Suppose you ...

If Cell Contains Text From List Then Return Value in Excel

In this lesson, I'll demonstrate 5 effective approaches to find if a cell contains text from a particular list and then how to return value in Excel. ...

ExcelDen
Logo