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.

Daily Tips For Your Phone

Get the Gadget Hacks newsletter for new tips every day.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest