LAMBDA function.Create your own function.(Microsoft Excel)
Includes usage of the LAMBDA function and exa ...
COUNTA function.Get non-blank counts.(Microsoft Excel)
Includes usage of the COUNTA function and exa ...
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 exa ...
CONCAT Function. Concatenate strings.(Microsoft Excel)
Includes usage of the CONCAT function and exa ...
Read text and table data from images.(Microsoft Excel)
Introduction to the use of OCR added in Octob ...
Formula to randomly extract a specified number of cells from a range of cells.(Microsoft Excel)
Introduces formulas with examples of creating ...
Formulas to randomly reorder a range of cells.(Microsoft Excel)
Includes formulas and examples of use for ran ...
Formulas to extract text from a cell every specified number of letters.(Microsoft Excel)
Includes formulas for extracting a few charac ...
Formulas to sort text in cells.(Microsoft Excel)
Includes formulas for reordering cell values ...
Formulas to remove multiple types of characters from cell text.(Microsoft Excel)
Includes formulas and examples of using the S ...