Main Profile

At A Glance

Excel Magic Trick #240: Dynamic Range New Data At Top

OFFSET function. See how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom. See how use the Name Manager (Define Names) to create a named formula that defines a range of cells. See how to insert a dynamic range formula name into a chart.
Length: 07:31

Contact

Questions about Excel Magic Trick #240: Dynamic Range New Data At Top

Want more info about Excel Magic Trick #240: Dynamic Range New Data At Top? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question