SORT Function. Sort range of cells.(Microsoft Excel)
Includes how to use the SORT function, examples of its use, and how it differs from the SORT function.
REDUCE Function. Cumulative calculation of a cell range.(Microsoft Excel)
Includes usage of the REDUCE function and examples of its use.
MAP function. Decompose cell range and retrieve individual cells.(Microsoft Excel)
Includes usage of the MAP function and examples of its use.
RANDARRAY function. Random numbers in multiple cells.(Microsoft Excel)
Includes how to use the RANDARRAY function, examples of its use, and how it differs from the RANDBETWEEN function.
LAMBDA function.Create your own function.(Microsoft Excel)
Includes usage of the LAMBDA function and examples of its use.
COUNTA function.Get non-blank counts.(Microsoft Excel)
Includes usage of the COUNTA function and examples of its use.
OFFSET Function. Get a cell by specifying the distance from the reference cell, height and width.(Microsoft Excel)
Includes usage of the OFFSET function and examples of its use.
CONCAT Function. Concatenate strings.(Microsoft Excel)
Includes usage of the CONCAT function and examples of its use.
WRAPROWS and WRAPCOLS functions. Sort specified range of cells in a single column or row by a specified number of rows or columns.
Includes usage of the WRAPROWS and WRAPCOLS functions and examples of its use.
VSTACK and HSTACK functions.Merge multiple range of cells.(Microsoft Excel)
Includes information on the VSTACK and HSTACK functions, examples of their use, and examples of combining them with o ...