IFERROR Function Archives

How to Create Leave Tracker in Excel (Download Free Template)

May 25, 2022 Excel Basics

Leave tracker is a widely used task for the human resource department to track every people for their vacation and working days. Almost every ...

Multiple Linear Regression on Excel Data Sets (2 Methods)

May 22, 2022 Data Analysis with Excel

This article illustrates how to perform multiple linear regression on data sets in excel. You will learn 2 easy ways to do that here. Linear ...

How to Split Names Using Formula in Excel (4 Easy Methods)

Apr 28, 2022 Excel Formulas

In Microsoft Excel, there must have some cases when you need to split the full name. Excel has several methods to do this. It actually reduces your ...

Excel Formula to Separate First Middle and Last Name (With Example)

May 19, 2022 Excel Formulas

This article will show how to separate the first name, middle name, and last name with the help of an Excel formula. To get a quick view on this, ...

How to Extract Text after Second Comma in Excel (6 Methods)

Apr 20, 2022 Excel Formulas

If you are looking for some special tricks to extract text after the second comma in Excel, you've come to the right place. In Microsoft Excel, there ...

How to Remove Text from an Excel Cell but Leave Numbers (8 Ways)

Apr 24, 2022 Excel Formulas

Sometimes we insert both the texts and numbers into the same Excel cell. For some reason, we may want to remove the texts from the cell keeping only ...

How to Extract Text After Last Space in Excel (5 Ways)

Apr 5, 2022 Excel Formulas

While using Excel, we often need to strip our text Cells and need part of our data, like the need of having the last part of the word of the long ...

How to Extract Specific Data from a Cell in Excel (3 Examples)

Apr 6, 2022 Excel Basics

Excel provides different ways to extract different data, mostly relying on different functions. Some may be extracted directly from specific ...

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

Apr 9, 2022 Advanced Excel

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

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

Apr 9, 2022 Excel Formulas

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 Convert Number to Text for VLOOKUP in Excel (2 Ways)

Mar 31, 2022 Excel Formulas

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 Copy Rows Automatically in Excel to Another Sheet (4 Methods)

May 25, 2022 Excel Basics

In this tutorial, we will demonstrate the methods to automatically copy rows in excel to another sheet. Microsoft Excel does not provide any feature ...

How to Convert Columns to Rows in Excel Based On Cell Value

May 25, 2022 Excel Formulas

Often, we need to convert columns to rows in excel based on cell value. This based on cell values conversion demands a criterion to be imposed on a ...

How to Calculate Percentage of Time in Excel (4 Suitable Examples)

May 24, 2022 Excel Formulas

In this tutorial, I will show you how to calculate the percentage of time in excel using the basic percent formula. Besides, I will show some ...

Excel Formula to Copy Text from One Cell to Another Sheet

May 25, 2022 Excel Basics

Often, we have to deal with multiple worksheets in Excel. Therefore, we roam around the sheets to look for an entry or value. Excel formula to copy ...