PIVOTBY function. Summary table by grouping by two axes.(Microsoft Excel)
Japanese version.
The PIVOTBY function is a function that was newly added in the September 2024 update. This fu ...
GROUPBY function. Summary table by grouping by one axis.(Microsoft Excel)
Japanese version.
The GROUPBY function is a function that was newly added in the September 2024 update. This fu ...
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 ...