Spill. Usage, advantages and disadvantages of Spill. (Dynamic array formulas.)
Japanese version. Spill is a feature that was ...
UNIQUE function. Remove duplicates in range of cells.(Microsoft Excel)
The UNIQUE function is a related function of ...
Name Manager, which defines a name for a cell range.(Microsoft Excel)
Naming cell ranges can make formulas easier t ...
SORTBY Function. Sort range of cells.(Microsoft Excel)
The SORTBY function is a Spill related functi ...
ROWS and COLUMNS functions. Get the number of rows and columns in a cell range.
Japanese version. Function to get the number ...
FIND Function. Finds the position of a string.(Microsoft Excel)
Japanese version. The FIND function is used t ...
Formula to get the last result with the VLOOKUP function.(Microsoft Excel)
Japanese version. When there are multiple res ...
INDEX Function. Retrieves values by specifying range of cells, number of rows, and number of columns.(Microsoft Excel)
Japanese version. The INDEX function is a fun ...
SUMIF function. Sum the values of cells matching the criteria.(Microsoft Excel)
Japanese version Extended version of the SUM ...
MATCH Function. Obtains the relative position of a cell as a result of a search.(Microsoft Excel)
Japanese version. Searches within a range of ...