• MVP Logo
  • Recent Forum Posts

    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 Today, 05:35 PM Go to last post
    p45cal

    Complex counting help

    Attached adjusted accordingly....

    p45cal Yesterday, 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 Yesterday, 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 Yesterday, 03:05 PM Go to last post
    Mr_E_Man

    Updated sheet with manual counts

    AliGW,

    Thank you for the quick response to my question! Please find attached the updated sheet with the manual count inserted for the first...

    Mr_E_Man Yesterday, 02:46 PM Go to last post