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!
CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in new cell.
COUNT function is used to get the total count of Number values in range or list.COUNT Function has one required and optional arguments.
AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.
Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.
MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1
COUNTA function is used to get the total count of Any-value or Non-Blanks in range. COUNTA Function has one required and optional argument: value1, value2