Exceljet

Quick, clean, and to the point

Excel 365

The functions below are new in Excel 365.

Excel ARRAYTOTEXT function
The Excel ARRAYTOTEXT function converts an array or range to a text string. The result can optionally include or omit curly braces.
Excel BYCOL function

The Excel BYCOL function applies a LAMBDA function to each column in a given array and returns one result per column as a single array. In the example shown, data is the named range C5:H9....

Excel BYROW function

The Excel BYROW function applies a LAMBDA function to each row of a given array and returns one result per row in a single array. In the example shown, data is the...

Excel FIELDVALUE function

The Excel FIELDVALUE function extracts a given field value from a data type. The field is specified by name and provided as a text value.

Excel FILTER function

The Excel FILTER function filters a range of data based on supplied criteria, and extracts matching records.

Excel LAMBDA function

The Excel LAMBDA function provides a way create custom functions that can be reused throughout a workbook, without VBA or macros.

Excel LET function

The Excel LET function lets you define named variables in a formula. There are two primary reasons you might want to do this: (1) to improve performance by eliminating redundant calculations and (2) to make more complex formulas easier to read...

Excel MAKEARRAY function

The Excel MAKEARRAY function returns a array with specified rows and columns, based on a custom LAMBDA calculation. MAKEARRAY can be used to create arrays with variable dimensions where values...

Excel MAP function

The Excel MAP function "maps" a custom LAMBDA function to each value in a supplied array. The LAMBDA is applied to each value, and the result from MAP is an array of results with the same dimensions as the original...

Excel RANDARRAY function

The Excel RANDARRAY function generates an array of random numbers between. The size or the array is is specified by rows and columns arguments. Generated values can be either decimals or whole numbers.

Excel REDUCE function

The Excel REDUCE function applies a custom LAMBDA function to each element in a given array and accumulates results to a single value.

Excel SCAN function

The SCAN function applies a custom LAMBDA function to each element in a given array and returns an array that contains the intermediate values created during the...

Excel SEQUENCE function

The Excel SEQUENCE function generates a list of sequential numbers in an array. The array can be one dimensional, or two-dimensional, determined by rows and columns arguments. 

Excel SORT function

The Excel SORT function sorts the contents of a range or array in ascending or descending order. Values can be sorted by one or more columns. SORT returns a dynamic array of results.

Excel SORTBY function
The Excel SORTBY function sorts the contents of a range or array based on the values from another range or array. The range or array used to sort does not need to appear in results.
Excel STOCKHISTORY function

The Excel STOCKHISTORY function retrieves historical stock price information based on a given symbol and date range. The primary purpose of STOCKHISTORY is to get the history of a financial instrument over time. The result is an array of values...

Excel UNIQUE function
The Excel UNIQUE function returns a list of unique values in a list or range. Values can be text, numbers, dates, times, etc.
Excel XLOOKUP function

The Excel XLOOKUP function is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP.  XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal...

Excel XMATCH function

The Excel XMATCH function performs a lookup and returns a position in vertical or horizontal ranges. It is a more robust and flexible successor to the MATCH function. XMATCH supports approximate and exact matching, reverse search, and wildcards...