# Array Formulas (CSE)

### Excel Array Formulas: returning multiple values

array Formulas can return a single value or multiple values. In the first case, to display the result would require one cell in the second range. this article will look at the array formula that return multiple values.

### EXCEL Functions: ROW

ROW(), the English version ROW(), calculates line number defined by the link: formula =ROW(B5) will return 5.

### Array Constants in EXCEL

an Array of values (or array constant or array of constants) is a set of numbers or text values that can be used in array formulas. Array constants must be entered in a specific format, for example, {1:2:3:4:5} or for text values {"North":"SOUTH","East":"West"}.

### Excel Array Formulas: returning single value

array Formulas can return a single value or multiple values. In the first case, to display the result would require one cell in the second range. In this paper, we consider array formulas that return a single value.

### Excel Array Formulas: Basics

introductory article for those who have never used an array formula.

### EXCEL Functions: TRANSPOSE

TRANSPOSE(), in the English version TRANSPOSE(), converts a vertical range of cells to horizontal and Vice versa. Learn to transpose (rotate) columns, rows, and ranges of values.

### EXCEL Functions: FREQUENCY

FREQUENCY(), the English version of FREQUENCY(), calculates the frequency of contact of the values in user-defined intervals and returns the corresponding array of numbers.

### Calendar in EXCEL

in order to create a calendar for a month, it is enough to write one the array formula.

### Array of Consecutive Integers in EXCEL

To build array formulas sometimes use a numerical sequence, for example {1:2:3:4:5:6:7}, entered directly into the formula. This sequence can be formed by manually entering the literal array, or using functions such as ROW(). Also using formulas you can dynamically change the length of the numeric sequence.