INDIRECT Function Archives

Separate Decimal Numbers from Text in Excel (6 Quick Ways)

May 10, 2022 Excel Formulas

This article will show how to separate decimal numbers from text in Excel. The following image highlights the purpose of this article. ...

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

How to Create a Table Array in Excel (3 Methods)

Apr 6, 2022 Excel Basics

While using the VLOOKUP or HLOOKUP function, there is a mandatory table array argument where we set the range for looking up values. So to learn how ...

How to Merge Data from Multiple Workbooks in Excel (5 Methods)

Mar 30, 2022 Excel Formulas

Are you worried about how to merge data from multiple workbooks and finding a proper guideline for that? No worries! You have come to the right ...

Data Validation Drop Down List with Excel Table Dynamic Range

Mar 23, 2022 Excel Formulas

This article illustrates how to create a data validation drop down list with an excel table dynamic range. This will save you a lot of time and ...

How to Reference Text in Another Cell in Excel (14 Ways)

Mar 23, 2022 Excel Formulas

When we are dealing with a large amount of data in Excel, sometimes we want to cite/reference certain texts from one cell to another for better ...

How to Reference Cell by Row and Column Number in Excel (4 Methods)

Mar 14, 2022 Excel Formulas

It’s quite common to use a cell reference in Excel. But except the traditional way, there are many ways by which you can reference cells by row and ...

How to Fix #REF! Error in Excel (6 Solutions)

Mar 16, 2022 Excel Basics

While working in Excel, facing the #REF! Error is one of the most common errors. But no worries, we are here to rescue you from that errors. This ...

How to Convert Single Columns to Rows in Excel with Formulas

May 24, 2022 Excel Formulas

In this article, I will show how to convert single columns to rows using excel formulas. Basically, when we copy data from any word editor to excel, ...

How to Calculate Average and Standard Deviation in Excel

May 24, 2022 Excel Basics

Calculating average and standard deviation are often necessary while doing data analysis. But the manual method of calculating those is not only ...

How to Combine Multiple Workbooks to One Workbook in Excel (6 Ways)

Mar 2, 2022 Excel Basics

Combining multiple workbooks into one master workbook can be quite intimidating. Depending on the contents and the number of worksheets in each of ...

How to Link Cell to Another Sheet in Excel (7 Methods)

May 23, 2022 Excel Formulas

Often, we have to deal with multiple worksheets in Excel and hover to different sheets to find a value. In this article, we demonstrate how to Excel ...

How to Link Sheets to a Master Sheet in Excel (5 Ways)

May 22, 2022 Excel Formulas

Often, we have to deal with multiple worksheets in Excel and hover to different sheets to find a value. In this article, we demonstrate how to link ...

How to Use Sheet Name Code in Excel (4 Applications)

May 22, 2022 Excel Formulas

In this article, we will learn how to use and get sheet name code to excel. In Microsoft Excel, we can use the sheet name directly in a formula as a ...