Learn Excel from Bill Jelen with this daily 2 minute video podcast.
In today's dueling podcast, how to turn a range upside down. Episode #1015 shows you how.
Labels: array formula, Dynamic Range, formulas
posted by Bill at 9:00 AM
Andre provides a set of formulas to chart the last rolling six months of data. Episode 1013 shows you how.
Labels: Dynamic Range
posted by Bill at 9:00 AM
Ally asks how to have a chart automatically extend as you type new data. The classic solution is to use a pair of dynamic named ranges using OFFSET. While this can be painful, Episode 993 shows how to set it up. Be sure to watch Episode 994 tomorrow for an easier way in Excel 2003-2007.
Labels: charting, Dynamic, Dynamic Range, Offset
posted by Bill at 9:00 AM
Joe sends in a tip about converting your pivot table source data to a dynamic range. While this used to mean using the OFFSET function, now it simply means using Ctrl+L (in Excel 2003) or Ctrl+T (in Excel 2007). Episode 825 shows you how.
Labels: Dynamic Range, List, Pivot Table, Table
posted by Bill at 9:00 AM
Jonathan is frustrated that his validation scrollbars start in the midst of several blank cells that he set up in his validation list. He was doing this to allow room for future growth in the list.
Labels: Dynamic Range, Offset, Validation
posted by Bill at 9:00 AM
