ROW function is used to get the row reference number of the excel worksheet.
ROW Function has only one argument i.e. reference, where we need to give cell address/ reference.
=ROW(reference)
reference argument is used to give the cell reference for which row sequence number is required
Here we have some examples, where:
We will be using ROW function as follows:
– If Range of cells given in reference argument, then function output will be leftmost row sequence number
– If cell reference is not given in reference argument, then function output will be row sequence number of formula cell
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
MID function is used for extracting the mid characters from the available string. The output of the function returns the extracted characters in new cell.
REPT function is used to repeat the text or cell reference to multiple times
RANK function performs the Ranking in a range or list of numbers. Function returns the rank position and can assigned as highest or lowest value as 1st Rank
COUNT function is used to get the total count of Number values in range or list.COUNT Function has one required and optional arguments.
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
ROWS function is used to get the total count of rows in an array or in cells range in an excel worksheet.