- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
-
Functions A to C
- ABS
- ACCRINT
- ACCRINTM
- ACOS
- ACOSH
- ACOT
- ACOTH
- ADDRESS
- AGGREGATE
- AMORDEGRC
- AMORLINC
- ANCHORARRAY
- AND
- ARABIC
- AREAS
- AREASPARKLINE
- ARRAYTOTEXT
- ASC
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BAHTTEXT
- BASE
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BETA.DIST
- BETA.INV
- BETADIST
- BETAINV
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BINOM.DIST
- BINOM.DIST.RANGE
- BINOM.INV
- BINOMDIST
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
- BOXPLOTSPARKLINE
- BULLETSPARKLINE
- BYCOL
- BYROW
- CASCADESPARKLINE
- CEILING
- CEILING.MATH
- CEILING.PRECISE
- CELL
- CHAR
- CHIDIST
- CHIINV
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CHISQ.TEST
- CHITEST
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COLUMNSPARKLINE
- COMBIN
- COMBINA
- COMPLEX
- CONCAT
- CONCATENATE
- CONFIDENCE
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONVERT
- CORREL
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- COVAR
- COVARIANCE.P
- COVARIANCE.S
- CRITBINOM
- CSC
- CSCH
- CUMIPMT
- CUMPRINC
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
- Functions T to Z
-
Functions A to C
ANCHORARRAY
This function returns the entire spilled range for the dynamic array in cell.
Syntax
ANCHORARRAY (cell)
Argument
ANCHORARRAY function has the following argument:
| Argument | Description |
|---|---|
| Cell | [Required] Specifies the cell that contains the dynamic array. |
Data Types
Returns the spilled range.
Version Available
This function is available in product version 13.0 or later.