Accepting Arrays

The following is a list of functions that can accept arrays

AGGREGATEThe aggregate of values in a list, table or cell range.
LARGEThe kth largest value in a list or array of numbers.
SMALLThe kth smallest value in a list or array of numbers.
PERCENTILE.EXCThe number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INCThe number corresponding to a particular percentage from an array of numbers (inclusive).
QUARTILE.EXCThe number corresponding to a particular percentage from an array of numbers (exclusive).
QUARTILE.INCThe 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)



© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext