IFERROR Function

Lookup and Return Multiple Values Concatenated into One Cell in Excel

In Microsoft Excel, there are a number of suitable techniques to lookup a criterion and then return multiple values concatenated into one cell based ...

How to Use RANK Function in Excel (With 5 Examples)

The simplest technique to establish a number's relative position in a list of numbers is to sort the list in descending (from largest to smallest) or ...

How to Use HLOOKUP Function in Excel (8 Suitable Approaches)

In Microsoft Excel, HLOOKUP or Horizontal Lookup function is generally used to extract data from a table or an array based on searching for a ...

How to Use FILTER Function in Excel (9 Easy Examples)

Excel 365 provides us a powerful function for automatically filtering our datasets, named the FILTER function. It makes our task easier by using this ...

How to use IFERROR Function in Excel (3 Examples)

There are several logical functions in Excel to perform various logical operations easily and swiftly. Today we are going to show you how to use the ...

Excel Sort Dates in Chronological Order (6 Effective Ways)

Microsoft Excel presents various sort options. Sorting may differ in terms of our needs and conditions. What we need to know is the correct and ...

How to Filter Data in Excel using Formula

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

3 Easy Ways to Sum Top n Values in Excel

Today I will be showing how you can sum any top n values from a data set in Microsoft Excel. Download Practice Workbook 3 Easy Ways to Sum ...

Excel Find Similar Text in Two Columns

Depending on the circumstances you may need to find similar text within two columns in Excel. Today, we are going to show you how to find similar ...

Return Multiple Values in Excel Based on Single Criteria (3 Options)

Today I am going to show how you can return multiple values based on single criteria in Microsoft Excel. Download Practice Workbook Return ...

How to Match Multiple Criteria from Different Arrays in Excel

Finding cells that satisfy multiple criteria from different arrays is a typical task in Excel. There are many ways to accomplish this task. In this ...

How to Extract Unique Values Based on Criteria in Excel

Extracting unique values based on single or different criteria is very common in office & business. Microsoft Excel has also added a few useful ...

If Cell Contain Word Then Assign Value in Excel (4 Formulas)

If you want to assign value to a cell based on a certain word in another cell then you'll need to build a formula because Excel doesn't provide a ...

How to Find Unique Values from Multiple Columns in Excel

Today I will be showing how you can extract unique values from multiple columns in Microsoft Excel. Download Practice Workbook How to Find ...

Extract Only Numbers from Excel Cell (6 Useful Methods)

Although Microsoft Excel has not provided a straight formula or syntax to extract only numbers from the cells, but we can incorporate a wide range of ...

ExcelDemy
Logo