• Twitter
  • Google+
  • Pinterest
  • RSS
Excel Unplugged

Tag Archives: ROW 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 ...

    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 ...

    Sum of ten largest values
    • June 24, 2014

    This will be a short lesson on three great and sadly unknown functions and how to use them as an array function. The eighth LARGEst value One of my favorite ...