Home MMForExcel Add-in Basic modeling Ranges

SQL-like

SQL-like functions

Sort By

Newest
Most likes
Most views

MM_GROUPBY function

Description MM_GROUPBY function groups all values based on keys and and applies a grouping function (SUM, AVG, MIN, MAX). Syntax...

November 18th, 2021 627 views 0 likes
MM_LEFTINNERJOIN and MM_RIGHTINNERJOIN functions

Description The two functions return a table joining two ranges according to matching keys. If a key from a range...

November 18th, 2021 257 views 0 likes
MM_LEFTOUTERJOIN and MM_RIGHTOUTERJOIN functions

Description These functions join two input ranges according to matching keys. Even if keys can not be matched, elements from...

November 18th, 2021 210 views 0 likes
MM_MIX function

Description The MM_MIX function performs a combination of two ranges by repeating the elements of Range2 for each element in...

November 18th, 2021 295 views 0 likes