AREAS function.Get the number of regions within a specified cell range.(Microsoft Excel)
Japanese version.
Get the number of regions within a specified cell range.
This is the number of contiguo ...
FORMULATEXT function.Acquire formulas in specified cells as strings.(Microsoft Excel)
Acquire formulas in specified cells as strings.
How it works=FORMULATEXT(reference)ArgumentOmissionSpecifyreferenc ...ADDRESS function.Get cell addresses by specifying row and column numbers.(Microsoft Excel)
Japanese version.
Get cell addresses by specifying row and column numbers.
It is rarely used alone, but i ...
INDIRECT function.Specify a cell address as a string and get the value of that cell.(Microsoft Excel)
Japanese version.
Specify a cell address as a string and get the value of that cell.
By itself, this func ...
HYPERLINK function. Set hyperlinks to jump to Web pages or files on disk.
Set hyperlinks to jump to Web pages or files on disk.
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.
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.
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 ...
SORTBY Function. Sort range of cells.(Microsoft Excel)
The SORTBY function is a Spill related function implemented in 2019.
It is a function to sort a given list in the ...
ROWS and COLUMNS functions. Get the number of rows and columns in a cell range.
Japanese version.
Function to get the number of rows and columns in a range of cells specified in the argument. ...