• Twitter
  • Google+
  • Pinterest
  • RSS
Excel Unplugged

Tag Archives: OFFSET function

Creating a dynamic Dropdown List with Data Validation from another workbook with a little help from Power Query
    • October 14, 2014

    Probably the longest title of all times, but it leads to something great. First let’s explain Power Query. Power Query is an AddInn for Excel and part of ...

    Dynamic ranges in Excel
    • October 9, 2013

    For the purposes of this article (if you wish to follow long and I strongly suggest you do so) we will be using a workbook that has the A2:E10 Range filled with the ...