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.