In this article, we will learn how to get last row number of the last non blank cell in a column in Microsoft Excel.
Consider a scenario in which you want to find the last non blank cell in a column.
Using a combination of three functions including ROW, COUNTA, and OFFSSET, you can devise an excel formula for last row which will find out the cell number of the last non blank cell in a column.
ROW: Returns the row number of a reference.
Reference: It is a reference to a cell or range of cells.
COUNTA: Counts the number of cells in a range that is not empty.
value1: The first argument representing the values that you want to count.
value2: This is optional. It represents the values that you want to count
There can be maximum 255 arguments. Refer below screenshot:
OFFSET: Returns a reference to a range that is a given number of rows and columns from a given reference.
reference: It is a reference to a cell or range of cells from which the OFFSET will be applied.
rows: The number of rows up or down that you want to apply as the offset to the range.
cols: The number of columns left or right that you want to apply as the offset to the range.
height: This is optional. It is the number of rows that you want the returned reference to be.
width: This is optional. It is the number of columns that you want the returned reference to be.
Let us take an example:
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.