ARRAYAREA
Description
Returns the containing range of the array formula, based on the single cell address that
you specify. The array can originate either in a Workday report or an array formula. This
function helps you create formulas that operate on arrays where the cell range is unknown or
changes over time.
Syntax
ARRAYAREA(
ref_cell
)
- ref_cell: The cell reference. Make sure you enter only a single cell address and not a range.
Example
The example is based on this table, where the data in A1:B3 is an array formula result set:
A | B | |
|---|---|---|
1
| 4 | 6 |
2
| 8 | 10 |
3
| 14 | 22 |
Formula | Result |
|---|---|
=ARRAYAREA(B2) | 4 6
8 10
14 22
|
Related Functions
COMPARE
GROUPBY
REMOVEROWS
SORT
SORT2