Ranges
Range and list functions.
The first character in a list has an index of 1 (like in strings).
See all of the Functions.
| Average | Calculates the arithmetic mean of the values in a list of values, range(s), or list(s). |
| Cherche | Searches for a sub-string of a character string and returns its position. |
| Count | Counts the number of non-empty numerical cells in a value set. |
| CountCells | Counts the number of cells in a set of cells. |
| CountEqual | Counts the number of values in a value set that are equal to a specific value. |
| CountIf | Counts the number of values in a value set that meet a condition. |
| CountVal | Counts the number of non-empty cells in a value set. |
| DecodeDeltaSeries | Returns a list of numbers from a Delta encoded string entered as a parameter. |
| DecodeDeltaSeriesXY | Returns a list of numbers from a Delta encoded string entered as a parameter. |
| Decoupe | Splits a string based on a delimiter and returns a list of sub-elements. |
| EcarType | |
| EcarTypeP | |
| Etendue | |
| Find | Searches for a sub-string of a character string and returns its position. |
| Haversine | Computes the distance on a sphere. |
| Index | |
| IndexOf | Searches for an element in a list value and returns its index. |
| Interlace | Interlaces two or more lists/values in a list. |
| Join | Joins a set of elements in the form of a single string with separators. |
| Length | |
| List | Combines a set of values into a single list value. |
| ListExclude | Excludes items from a list. |
| ListIf | Compute a list of values that meet a condition. |
| ListIntersect | Computes the intersection of multiple lists. |
| ListPack | Deletes empty elements from a set of list values. |
| ListPolynomial | Applies a polynomial to the items of a list. |
| ListRemove | Removes items from a list. |
| ListReverse | Reverses the items of a list. |
| ListSign | Computes the sign of values in a list. |
| ListUnique | Combines a set of values into a single list value with no duplicates. |
| Lookup | Looks up a value in a search set and returns the corresponding value (with the same Index) in a set of results. |
| LookupAll | Looks up a value in a search set and returns all of the corresponding values (with the same Index) in a set of results. |
| Max | Calculates the (numerical) maximum out of all of the values in a list of values, ranges and/or lists. |
| Median | |
| Mediane | |
| Min | Calculates the (numerical) minimum out of all of the values in a list of values, ranges and/or lists. |
| Moyenne | |
| Nb | |
| NbCells | Alias of CountCells |
| NbSi | |
| NbVal | |
| Numbers | Returns an arithmetic progression of numbers. |
| Range | |
| RangeRatio | |
| Recherche | |
| RechercheTous | |
| Slice | Extracts a sub-list from a list. |
| Somme | Alias of Sum. |
| SommeSi | |
| SortByNum | Sorts a list, based on the ascending numerical order of another list. |
| SortByText | Sorts a list, based on the ascending alphabetical order of another list (case insensitive). |
| SortNum | Sorts a list or a list of values by ascending numerical order of the values. |
| SortText | Sorts a list or a list of values by ascending alphabetical order of the values (case sensitive). |
| Split | Splits a string based on a delimiter and returns a list of sub-elements. |
| StdDev | |
| StdDevP | |
| Sum | Calculates the numerical sum of the values in a list of values, ranges and/or lists. |
| Sum2 | Calculates the numerical sum of the squared values in a list of values, ranges and/or lists. |
| SumIf |