=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!
This guide will show you quick and easy methods to find the number of days between dates in Excel.
Do you need to know how many days are between two dates? Maybe you want to find out the days between today and a date in the past or future, or just count the working days between two dates? Whatever you need, one of the examples below will help you find the solution
Watch: How to use COUNTIF & COUNTIFS Function in Excel? What is COUNTIF Function? In Excel, “COUNTIF” counts the number of cells within a range that meet a single specified criteria. Click here to Read…
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.
LOWER function is used for changing the format of any text or string to LOWER case.
Watch: How to use WEEKNUM Function in Excel? What is WEEKNUM Function? The WEEKNUM function in Excel returns the week number of a given date. It is a DATE and TIME function that can be…
COUNTBLANK function is used to get the total count of Blank or Empty cell in range.
COUNTBLANK Function has one required argument i.e. range.