Get column and row number

Row numbers are easy to identify because they use numbers on the left side of a workspace. So even if you use a very large dataset, you can always look at the left side of the screen to see the number which corresponds to the row.

It’s much more complicated when it comes to columns because columns use letters instead of numbers.

Of course, there is no problem when we use a letter from the begging of the alphabet, but we need to think a bit when it comes to the letters closer to the end.

It’s even more complicated when we need to tell what is the number of, for example, column NBJ.

To determine these numbers, we can use functions ROW and COLUMN.

  • ROW shows the row number.
  • COLUMN shows the column number.

Take a look at the following example.

B3: The ROW function returns 3 as the current row number.

C3: The COLUMN function returns 3 as the current column number (C).

D3: ROW returns 234 as the row number of cell NBJ234.

D4: COLUMN returns 9526 as the column number of cell NBJ234.