Please fill out the contact form below and we will reply as soon as possible.
SQL-like functions
Description Concatenates data from a range using a specified separator. This is particularly useful for the Setup parameters editor . ...
November 18th, 2021 333 views 0 likes
Description Binds ranges horizontally. Creates a new range by putting together ranges side-by-side. Syntax =MM_HUNION(RangeOutput, [RangeOutput2], [RangeOuput3], [...]) RangeOutput First...
November 18th, 2021 329 views 0 likes
Description Returns the element of a table corresponding to a specified combination of criteria for which the first columns of...
November 18th, 2021 788 views 0 likes
Description Removes duplicates from the key range and filters the output ranges accordingly. Syntax =MM_REMOVEDUPLICATES(Key, Output1, [Output2], [Output3]) Key Range...
November 18th, 2021 420 views 0 likes
Description MM_SORTRANGE sorts a target multidimensional range. Syntax =MM_SORTRANGE(Obj, SortingOrderObj,[Name, Index],[Name2, Index2],..) Obj: Range on which you want to perform...
November 18th, 2021 602 views 0 likes
Description Binds ranges horizontally. Creates a new range by putting together ranges side-by-side. Syntax =MM_VUNION(RangeOutput, [RangeOutput2], [RangeOutput3]) RangeOutput First range...
November 18th, 2021 411 views 0 likes
Description Filters specified ranges with a given key. Syntax =MM_FILTER(Key, Output1, [Output2], [Output3]) Key Range that contains values equal to...
November 18th, 2021 736 views 0 likes
Description Sorts the numerical values of the dimensions of a specified cell. Warning This function is deprecated and available for model...
November 18th, 2021 509 views 0 likes
October 5th, 2022 518 views 0 likes