Exceljet

Quick, clean, and to the point

Excel 365

The functions below were introduced in Excel 365, and are not yet available in any other version of Excel.

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 makes it easier to write certain complex formulas, by making it possible to declare and assign values to variables inside a formula.
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 SEQUENCE function

The Excel SEQUENCE function generates a list of sequential numbers in an array. The array can be one dimensional, or two-dimensional. Start and step values are arguments.

Excel SINGLE function

The Excel SINGLE function returns a single value using implicit intersection. The SINGLE function was originally introduced with Dynamic Arrays, but later deprecated in favor of the...

Excel SORT function

The Excel SORT function sorts the contents of a range or array. 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 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...