INDIRECT Function Archives

How to Use Named Range in Excel VLOOKUP Function

Jan 26, 2023 Excel Formulas

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

Jan 23, 2023 Excel Formulas

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

Jan 23, 2023 Excel Formulas

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)

Jan 24, 2023 Excel Formulas

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)

Jan 30, 2023 Excel Formulas

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)

Jan 4, 2023 Excel Formulas

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)

Jan 7, 2023 Excel Charts

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)

Jan 2, 2023 Excel Formulas

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

Jan 2, 2023 Excel Formulas

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)

Jan 1, 2023 Advanced Excel

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)

Nov 29, 2022 Advanced Excel

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)

Jan 1, 2023 Excel Formulas

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)

Dec 29, 2022 Advanced Excel

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)

Jan 1, 2023 Advanced Excel

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

Jan 1, 2023 Excel Basics

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