Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

INDIRECT Function

How to Use Named Range in Excel VLOOKUP Function

The VLOOKUP function is one the most commonly used functions in Microsoft Excel. We use the VLOOKUP function to find values in a table to extract ...

How to Use Excel LARGE Function with Duplicates in Excel

The LARGE function cannot identify the unique nth largest value if duplicates are available in an array. In this article, you will find the nth ...

How to Use Multiple IF Statements in Excel Data Validation

In Microsoft Excel, the IF function is one of the widely used ones for conditional calculation. In Excel Data Validation, we can even use the IF ...

How to Do Union of Two Columns in Excel (5 Easy Ways)

In Excel, we often need to do union of two columns. We can manually merge two columns in Excel. But for a large, this will require a lot of time. ...

How to Calculate Quartile Deviation in Excel (4 Easy Methods)

This tutorial will demonstrate how to calculate quartile deviation in Excel. It is essential to use quartile deviation in almost every aspect of our ...

How to Use Excel DGET with Dynamic Criteria (with Precise Steps)

Have you ever wondered how to apply the DGET function of Excel for multiple dynamic criteria? The DGET function of Microsoft Excel is one of the ...

Performing Intersection of Two Data Sets in Excel (4 Easy Ways)

While working in Excel, sometimes we face situations where there are duplicate values in different columns or we opt to find the value of ...

How to Create Permutation Table in Excel (4 Easy Methods)

This tutorial will demonstrate how to determine Excel permutation table. We use the Permutation in Excel where in the data the order of the data ...

How to Calculate Permutations Without Repetition in Excel

Permutation is such a great mathematical concept that has a significant impact on every aspect of education. We can see its usage in math, quantum ...

How to Perform Pattern Matching in Excel (2 Suitable Methods)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In Excel, we ...

How to Resample Time Series in Excel (3 Examples)

If you are trying to resample time series in Excel, then you can follow this article. Sometimes you may need to redistribute the time spaces of your ...

How to Find All Combinations of 1 Column in Excel (2 Handy Ways)

In mathematics, calculating combinations of a certain number of characters is a very common practice. In fact, we can count these combinations in ...

How to Use REGEX without VBA in Excel (with Easy Steps)

If you are using REGEX without VBA in Excel, this article may help you in this regard. REGEX is the abbreviated form of the term "regular ...

How to Use REGEX to Match Patterns in Excel (6 Examples)

If you are trying to find a match with any REGEX pattern to your dataset in Excel, then this article may help you. A REGEX pattern is basically a ...

How to Apply Abbreviation Using Formula in Excel

While working in Excel, users often need to abbreviate text. The texts can be the name of a person, company, or organization. But there is no single ...

ExcelDemy
Logo