• MVP Logo
  • Recent Forum Posts

    p45cal

    Complex counting help

    The table in the latest file needs refreshing - I should have done that myself - sorry....

    p45cal 2020-08-05, 05:45 PM Go to last post
    Mr_E_Man

    Complex counting help

    Hi p45cal - I think there is still some error in the logic but your suggestion of using Power Query has been invaluable. I have been researching that...

    Mr_E_Man 2020-08-05, 05:35 PM Go to last post
    p45cal

    Complex counting help

    Attached adjusted accordingly....

    p45cal 2020-08-04, 11:31 PM Go to last post
    Mr_E_Man

    Complex counting help

    Hi p45cal - the specific "DT" function is the only one that does not get counted for the keypad on the 2nd or 3rd reference, it is different...

    Mr_E_Man 2020-08-04, 05:55 PM Go to last post
    p45cal

    Complex counting help

    The attached contains a table at cell I6, which agrees with your totals except for the keypad count of the first site (1185) where I have counted the...

    p45cal 2020-08-04, 03:05 PM Go to last post