How to Use INDIRECT Function in Excel (12 Suitable Instances)

In Microsoft Excel, the INDIRECT function is generally applied to store a cell reference and then use the reference value with other functions to ...

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

How to use COLUMNS Function in Excel (3 Examples)

There are a number of functions in Excel to perform various lookup and search operations easily and swiftly. Today we are going to show you how to ...

How to Use COLUMN Function in Excel (4 Easy Examples)

Sometimes we may need to figure out or determine the column number of any specific cell. For this purpose, Excel provides a function named COLUMN. ...

How to Use TRUE Function in Excel (With 10 Examples)

The TRUE function has a special type of compatibility in returning results based on logical conditions. In this article, I’ll discuss the ins and ...

Excel Compare Text in Two Columns (7 Fruitful Ways)

Comparing text in two columns in Excel is a significant task in our daily life especially when you have to find something compared to the given text. ...

Excel Compare Two Lists and Return Differences (7 Ways)

Sometimes we need to compare two lists in Excel for various purposes. In Excel, the list can be presented in two ways. It can be column-wise or ...

Excel Find Similar Text in Two Columns (3 Ways)

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

Find Duplicates in Two Columns in Excel (6 Suitable Approaches)

Microsoft Excel has provided numerous methods to find duplicates in two or more columns. In this article, you'll learn all simple & useful tricks ...

How to Find the Max Value and the Corresponding Cell in Excel (4 Quick Ways)

Today I will be showing how you can find the max value and the corresponding cell from a set of data in Microsoft Excel. Download Practice ...

VLOOKUP Max Value in Excel (With Limitations and Alternative Options)

Today I will be showing how you can extract the max (maximum) value from a database using the VLOOKUP function of Microsoft Excel. Download ...

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

Excel if One Cell Equals another then Return another Cell

MS Excel provides various options and methods to make our tasks easier. In this article, I will show some ways if we want to check cells one with ...

Excel Formula to Copy Cell value to Another Cell

Copying might be a monotonous phase while using Excel. Using formulas can bring some life to this copy task. The agenda for today’s tutorial is to ...

How to Calculate Grade Percentage in Excel (3 Easy Ways)

Microsoft Excel provides a number of fruitful & easy methods to calculate grade percentage. Here I’m going to show you the techniques with proper ... 