TEXT Function. Obtains text with formatting applied to numbers and dates.(Microsoft Excel)
Frequently used operators.(Microsoft Excel)
Japanese version. Operators are symbols used ...
CONCATENATE Function. Concatenate strings.(Microsoft Excel)
Japanese version. CONCATENATE is a function t ...
Spill. Usage, advantages and disadvantages of Spill. (Dynamic array formulas.)
UNIQUE function. Remove duplicates in range of cells.(Microsoft Excel)
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)
ROWS and COLUMNS functions. Get the number of rows and columns in a cell range.
FIND Function. Finds the position of a string.(Microsoft Excel)
Formula to get the last result with the VLOOKUP function.(Microsoft Excel)
When there are multiple results that match th ...