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.

Life Hacks for Your Smartphone

Fresh tips every day.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest