Returns the minimum value(s) in the list, {0}. The parameter, {1}, specifies the number of values to return or a filtering condition. The optional parameter, {2}, specifies how to compare values in the list.
- {0}: The list of values.
- {1}: If a number is specified, a list of up to {1} items in ascending order is returned. If a condition is specified, a list of items that initially meet the condition is returned. Once an item fails the condition, no further items are considered. If this parameter is null the single smallest value in the list is returned.
- {2}: [Opional] An optional
comparisonCriteria
value, may be specified to determine how to compare the items in the list. If this parameter is null, the default comparer is used.
Returns the median item of the list {0}. This function throws an exception if the list is empty. If there is an even number ...
Returns the member that is a specified number of positions following a specified member along the dimension of the member. ...
Returns the member that is a specified number of positions prior to a specified member along the dimension of the member. ...
Returns the minimum item in the list {0}, or the optional default value {1} if the list is empty. An optional comparisonCriteria ...
Returns the minimum value(s) in the list, {0}. The parameter, {1}, specifies the number of values to return or a filtering ...
Returns the nth item in the delimited list produced by the Path function, counting backwards from the last item in the path ...
Returns the nth item in the delimited list produced by the Path function, counting backwards from the last item in the path. ...
Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups ...
Returns the number of days in the month in the date , datetime , or datetimezone value {0}. {0}: A date , datetime , or datetimezone ...