Getting the row and column number of a cell
When you want to find the row or column number of a cell, you use ROW () and COLUMN () functions.
If you don't write anything in paranthesis, you get the order of row or column of the cell where the formula is written.
If you write a cell name in formulas, you will get the order of row or column of the cell which the formula refers.
Whereas " = ROW () " function gives the row number of B20, " = ROW (C10) " gives the row number of C10 without regarding where the formula is written.
Related Tutorials
Two dimensional lookup is obvious – we have a header row and a column and we want to look at the intersection of the two criteria’s.
Using ISEVEN() or ISODD() functions.
, ISTEXT(), ISNUMBER() and ISBLANK() functions.png)
Using IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions.
Latest
-
Understanding How HYPERLINK Works In Excel
Excel has a built in function to create hyperlinks &...
-
Understanding how MS Excel Query Works
“Query” in MS Excel has same meaning as ...
-
An Introduction To Excel Power Map
Our today’s post is about “Power Map&rdq...
-
Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying r...
-
Using “Calculated Items” For Analyzing A Pivot Table
In our last post, we explored how to use calculated ...
