Alphabetical - M

MAKEARRAY	(Microsoft 365) The array calculated by applying a LAMBDA function.
MAP	(Microsoft 365) The array formed by applying a map using a LAMBDA function.
MATCH	The position of a value in a list, table or cell range.
MAX	The largest value in a list, range or array.
MAXA	The largest value in a list, range or array (including logical values and text).
MAXIFS	(2019) The largest value in a list, range or array that satisfies multiple conditions.
MDETERM	The matrix determinant of an array.
MDURATION	The modified duration for a security that pays interest periodically.
MEDIAN	The median value in a list or array of numbers.
MID	The characters from the middle of a text string.
MIN	The smallest value in a list, range or array.
MINA	The smallest value in a list, range or array (including logical values and text).
MINIFS	(2019) The smallest value in a list, range or array that satisfies multiple conditions.
MINUTE	The minute as an integer given a date serial number.
MINVERSE	The inverse matrix of an array.
MIRR	The interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate).
MMULT	The matrix product of two arrays.
MOD	The remainder after division.
MODE	(MODE.SNGL) The value that occurs most frequently in a list or array of numbers.
MODE.MULT	The array of most frequent or repetitive values.
MODE.SNGL	The value that occurs most frequently in a list or array of numbers.
MONTH	The month as an integer given a date serial number.
MROUND	The number rounded to the desired multiple.
MULTINOMIAL	The multinomial of a set of numbers in a list or cell range.
MUNIT	(2013) The unit matrix or the specified dimension.

MAKEARRAY (Microsoft 365) The array calculated by applying a LAMBDA function.
MAP (Microsoft 365) The array formed by applying a map using a LAMBDA function.
MATCH The position of a value in a list, table or cell range.
MAX The largest value in a list, range or array.
MAXA The largest value in a list, range or array (including logical values and text).
MAXIFS (2019) The largest value in a list, range or array that satisfies multiple conditions.
MDETERM The matrix determinant of an array.
MDURATION The modified duration for a security that pays interest periodically.
MEDIAN The median value in a list or array of numbers.
MID The characters from the middle of a text string.
MIN The smallest value in a list, range or array.
MINA The smallest value in a list, range or array (including logical values and text).
MINIFS (2019) The smallest value in a list, range or array that satisfies multiple conditions.
MINUTE The minute as an integer given a date serial number.
MINVERSE The inverse matrix of an array.
MIRR The interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate).
MMULT The matrix product of two arrays.
MOD The remainder after division.
MODE (MODE.SNGL) The value that occurs most frequently in a list or array of numbers.
MODE.MULT The array of most frequent or repetitive values.
MODE.SNGL The value that occurs most frequently in a list or array of numbers.
MONTH The month as an integer given a date serial number.
MROUND The number rounded to the desired multiple.
MULTINOMIAL The multinomial of a set of numbers in a list or cell range.
MUNIT (2013) The unit matrix or the specified dimension.