Pivot, Summarize values by Maximum, 24-hour clock

  • Re: Pivot, Summarize values by Maximum, 24-hour clock


    Would be hard to do. Code runs by starting at bottom and going backwards towards top. So, it doesn't know before hand how many instances there will be. It'd be easier to build a concatenating formula afterwards, like:


    =IF(C2="Down Time","Down Time " & COUNTIFS(A$2:a2,a2,B$2:b2,B2),C2)


    And then that should give you something close to what you want.

    Best Regards,
    Luke M
    =======
    "A little knowledge is a dangerous thing."