Unique
in package
Table of Contents
Methods
- unique() : mixed
- UNIQUE The UNIQUE function searches for value either from a one-row or one-column range or from an array.
- countValuesCaseInsensitive() : array<string|int, mixed>
- exactlyOnceFilter() : array<string|int, mixed>
- uniqueByColumn() : mixed
- uniqueByRow() : mixed
Methods
unique()
UNIQUE The UNIQUE function searches for value either from a one-row or one-column range or from an array.
public
static unique(mixed $lookupVector[, mixed $byColumn = false ][, mixed $exactlyOnce = false ]) : mixed
Parameters
- $lookupVector : mixed
-
The range of cells being searched
- $byColumn : mixed = false
-
Whether the uniqueness should be determined by row (the default) or by column
- $exactlyOnce : mixed = false
-
Whether the function should return only entries that occur just once in the list
Return values
mixed —The unique values from the search range
countValuesCaseInsensitive()
private
static countValuesCaseInsensitive(array<string|int, string> $caseSensitiveLookupValues) : array<string|int, mixed>
Parameters
- $caseSensitiveLookupValues : array<string|int, string>
Return values
array<string|int, mixed>exactlyOnceFilter()
private
static exactlyOnceFilter(array<string|int, mixed> $values) : array<string|int, mixed>
Parameters
- $values : array<string|int, mixed>
Return values
array<string|int, mixed>uniqueByColumn()
private
static uniqueByColumn(array<string|int, mixed> $lookupVector, bool $exactlyOnce) : mixed
Parameters
- $lookupVector : array<string|int, mixed>
- $exactlyOnce : bool
uniqueByRow()
private
static uniqueByRow(array<string|int, mixed> $lookupVector, bool $exactlyOnce) : mixed
Parameters
- $lookupVector : array<string|int, mixed>
- $exactlyOnce : bool