Main Profile

At A Glance

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.
Length: 06:38

Contact

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

Want more info about Excel Magic Trick #135: Find Last Row & Column Dynamic Range? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question