MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Last row with data


Posted by Joe on November 26, 2001 1:10 PM

I am working with data in 2 worksheets where I continually enter new data into the rows, and I need to move the newest data (lowest row) into one master sheet that I can print out. I need to know a way to write a function so that the last row that contains data in a column will be displayed in the desired cell.


Posted by Juan Pablo on November 26, 2001 1:14 PM

One option, is, if Column A has numeric values:

=MATCH(9.99999E+307,A:A)

This will return the last row in A that has a number.

If you want to "retrieve" the value you can use:

=INDIRECT("A" & MATCH(9.99999E+307,A:A))

Juan Pablo