=ROW(reference)
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!
VBA Code to Count Color Cells With Conditional Formatting Have you ever got into situation in office where you need to count the cells with specific color in conditional formatted Excel sheet? If yes then…
An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.
Generate Random Numbers in Excel Using RAND We have got many instances where we needed to generate a random database or values. Rand function is very useful for the users who creates random database for…
TEXT function is used to change the formatting or appearances of the text. There are various types of formatting available.
Microsoft Excel “NOW” function is used to get the current Date and Time. It is very useful function and can be used in many ways.
https://youtu.be/HmJL_y93pAs WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date. Syntax:…