Excel Forum

Excel Magic Trick #135: Find Last Row & Column Dynamic Range

Create a dynamic range when there are blanks in the data set. Use an array formula to find the Last row or column used in a data set. See the functions: ROW, COLUMN, MAX, OFFSET.

Got a Question? Ask it Here in the Forum.