INDEX Function. Retrieves values by specifying range of cells, number of rows, and number of columns.(Microsoft Excel)
Japanese version.
The INDEX function is a function that retrieves the value of a cell by specifying the cell ra ...
MATCH Function. Obtains the relative position of a cell as a result of a search.(Microsoft Excel)
Japanese version.
Searches within a range of cells, and if there is a matching cell, returns the position of th ...
HLOOKUP function. Searching for data.(Microsoft Excel)
Japanese version.
The HLOOKUP function is similar to the VLOOKUP function, but the search direction is differen ...
VLOOKUP function. Searching for data.(Microsoft Excel)
Japanese version.
The VLOOKUP function is a function that retrieves cell values and has many uses.
However, ...
FILTER function. Get all rows matching the condition.(Microsoft Excel)
Japanese version.
The FILTER function is a related function of Spill that was implemented in 2019 to retrieve d ...
SORT Function. Sort range of cells.(Microsoft Excel)
Includes how to use the SORT function, examples of its use, and how it differs from the SORT function.
OFFSET Function. Get a cell by specifying the distance from the reference cell, height and width.(Microsoft Excel)
Includes usage of the OFFSET function and examples of its use.
WRAPROWS and WRAPCOLS functions. Sort specified range of cells in a single column or row by a specified number of rows or columns.
Includes usage of the WRAPROWS and WRAPCOLS functions and examples of its use.
VSTACK and HSTACK functions.Merge multiple range of cells.(Microsoft Excel)
Includes information on the VSTACK and HSTACK functions, examples of their use, and examples of combining them with o ...
CHOOSEROWS and CHOOSECOLS functions. Obtain rows and columns at specified positions from range of cells.(Microsoft Excel)
Includes usage of the CHOOSEROWS and CHOOSECOLS functions and examples of its use.