Array in Excel
First, we need to know what the term “array” means. an array is a single row or column, or in multiple rows and columns.
For Example, if you put your monthly expenditure into an array format, it would look like this.
{“Rent”,”Travel”,”Food”,”Petrol”}
Then, if you select cells A1 through D1, Enter the above array preceded by an equal sign (=) in the formula bar and press CTRL + SHIFT + ENTER, you will get the following result:
How to Create an Array Formula in Excel?
Array formulas in excel are important tools. A single formula can perform multiple calculations and replace thousand of useful formulas. Most of us have never used array functions in our excel sheet just because we don’t know how to use these formulas.
Array formulas is one of the most confusing excel features to learn. The aim of this tutorial is to make you learn all functions in a smooth way. In this article, we will learn about array, array formulas, how to enter array formulas into your excel sheet, and how to use array constant and array functions.
Contact Us