• Twitter
  • Google+
  • Pinterest
  • RSS
Excel Unplugged

Tag Archives: INDIRECT function

Last word in a string with an Array formula
    • November 11, 2014

    As promised in the Pragmatism vs. Purity in Excel article from last week, this week’s article will explain the following array formula ...

    Dependent Data Validation dropdown lists
    • September 2, 2014

    Our goal here, is to create a dropdown list by using Data Validation, where the contents of the list will be determined by another Data Validation Dropdown list. ...

    Convert Text to Numbers in Excel
    • July 29, 2014

    A task that comes about every so often in Excel and can be quite tricky. Now our ultimate goal is to get a number out of something like (text 1 text) or even ...