• MVP Logo
  • Recent Forum Posts


    Networkdays Calculation Array

    Thanks Ali!

    This is the work that I started on this project last night, which has infinitely improved the process from an entirely manual...

    Joecam Today, 12:12 AM Go to last post

    Excel 2010 does not see all open workbooks

    No need for you to apologize Ken, you can't control a comment before it is made. Just wanted to let you know what was going on so that you can keep a...

    rdwray Yesterday, 11:10 PM Go to last post
    Ken Puls

    Excel 2010 does not see all open workbooks

    snb, enough already. This was totally out of line. If you don't want to help this user, then don't help. But don't come in and mock and belittle them....

    Ken Puls Yesterday, 10:48 PM Go to last post
    Ken Puls

    VLOOKUP (as per Ken P)

    True enough, Kevin. That comment was made under the assumption that data in the lookup table did not have duplicates (I never use VLOOKUP against a table...

    Ken Puls Yesterday, 10:43 PM Go to last post

    VLOOKUP (as per Ken P)

    Wow, that is huge. This is the first I've seen anywhere for a Power Query VLOOKUP (exact match).
    It works!
    Ken, please add Table.Buffer to...

    kevinh7777 Yesterday, 09:33 PM Go to last post