SCAN function. Create a cell range for cumulative calculations.(Microsoft Excel)
Includes how to use the SCAN function, examples of its use, and how it differs from the REDUCE function.
How to remove duplicates and count them.(Microsoft Excel)
Japanese version.
There are situations where you want to exclude duplicates of the same data and calculate the ...
COUNT Function. Number of numbers.(Microsoft Excel)
Japanese version.
The COUNT function obtains the number of numeric values in a specified cell range.
How it ...How to put a blank in the first candidate in the pull-down.(Microsoft Excel)
Japanese version.
If you want to include a blank space as a choice in a pull-down menu (drop-down list), there ...
How to replace multiple texts with the SUBSTITUTE function.(Microsoft Excel)
Japanese version.
The SUBSTITUTE function for replacing text only supports replacing one text, not multiple tex ...
TEXT Function. Obtains text with formatting applied to numbers and dates.(Microsoft Excel)
Japanese version.
The TEXT function is a function to obtain text applied to a number or date with a display for ...
Frequently used operators.(Microsoft Excel)
Japanese version.
Operators are symbols used for four arithmetic operations, cell references.
Types of Opera ...CONCATENATE Function. Concatenate strings.(Microsoft Excel)
Japanese version.
CONCATENATE is a function to combine multiple strings, but has been deprecated since Excel 20 ...
Spill. Usage, advantages and disadvantages of Spill. (Dynamic array formulas.)
Japanese version.
Spill is a feature that was implemented in 2019.
This is a very beneficial feature for bo ...
UNIQUE function. Remove duplicates in range of cells.(Microsoft Excel)
The UNIQUE function is a related function of Spill added in 2019 that removes duplicates in a cell range.It is also p ...