Vloggest Entertainment

Watch all your favorite videostars!
  • Share this video
  • facebook
  • Google+
  • Twitter
  • submit to reddit Reddit
  • Tags
  • Show tags

Excel Magic Trick 584: Dynamic Range for Periodic Da...

ExcelIsFun Follow
  • Video description
  • 9 years ago
  • 46,338 views
  • 153 likes
  • 22 comments
See how to use the OFFSET function and Defined Names to create dynamic ranges for formulas so formulas update each period when a new data dump (copy and paste) is completed.
Vlogger of the day:

KSI

"I had no clue on what I wanted to do when I was younger, so I was pretty lucky with this YouTube thing.” Olajide "JJ" Olatunji (born 19 June 1993), better known by his online pseudonym, KSI, is an...

read more

  • Comments
  • Related videos