SEQUENCE function. Create sequential numbers in multiple cells.
Create sequential numbers in multiple cells.
TRANSPOSE function. Create a cell range with the rows and columns of the specified cell range swapped.(Microsoft Excel)
Create a cell range with the rows and columns of the specified cell range swapped.
MODE function. Get mode.(Microsoft Excel)
Function to get the mode.
However, this function has been deprecated, so use the MODE.SNGL function.
MODE.SNGL function and MODE.MULT function. Get mode.(Microsoft Excel)
Get mode (the number that appears most frequently).
FREQUENCY function. Create frequency distribution tables.(Microsoft Excel)
Japanese version.
Function to create a frequency distribution table.
However, it is not easy to use and t ...
ROW and COLUMN functions. Get the position of a cell column and row.(Microsoft Excel)
Japanese version.
The ROW and COLUMN functions are used to obtain the row and column numbers of a target cell.
Method of summing every other line.(Microsoft Excel)
If you want to sum every other line, you can simply open and select one line at a time if the table has little data, ...
How to find multiple texts with the FIND function.(Microsoft Excel)
The FIND function, which searches a string for the number of characters in a given string, allows only one character ...
AVERAGEIF function.Average of cell values matching the search criteria.(Microsoft Excel)
The AVERAGEIF function is an extended version of the AVERAGE function that displays the average value of cells that s ...
Relative cell reference and Absolute cell reference.(Microsoft Excel)
Japanese version.
There are two methods of cell referencing (specifying cells in formulas and functions): relat ...