Accepting Arrays
The following is a list of functions that can accept arrays
| AGGREGATE | The aggregate of values in a list, table or cell range. |
| LARGE | The kth largest value in a list or array of numbers. |
| SMALL | The kth smallest value in a list or array of numbers. |
| PERCENTILE.EXC | The number corresponding to a particular percentage from an array of numbers (exclusive). |
| PERCENTILE.INC | The number corresponding to a particular percentage from an array of numbers (inclusive). |
| QUARTILE.EXC | The number corresponding to a particular percentage from an array of numbers (exclusive). |
| QUARTILE.INC | The quartile of a data set (inclusive). |
| AGGREGATE The aggregate of values in a list, table or cell range. |
| LARGE The kth largest value in a list or array of numbers. |
| SMALL The kth smallest value in a list or array of numbers. |
| PERCENTILE.EXC The number corresponding to a particular percentage from an array of numbers (exclusive). |
| PERCENTILE.INC The number corresponding to a particular percentage from an array of numbers (inclusive). |
| QUARTILE.EXC The number corresponding to a particular percentage from an array of numbers (exclusive). |
| QUARTILE.INC The quartile of a data set (inclusive). |
AGGREGATE
Aggregate(function_num, options, array [,k])
LARGE
Large(array, k)
SMALL
Small(array, k)
PERCENTILE.EXC
Percentile.Exc(array, k)
PERCENTILE.INC
Percentile.Inc(array, k)
QUARTILE.INC
Quartile.Exc(array, k)
QUARTILE.EXC
Quartile.Inc(array, quart)
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext