How To: Do dynamic range w/Excel's OFFSET function & top data

Do dynamic range w/Excel's OFFSET function & top data

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 240th installment in their series of digital spreadsheet magic tricks, you'll learn 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.

Get the Gadget Hacks Daily

Life hacks for your smartphone.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest