7 Replies Latest reply on May 4, 2018 5:36 AM by Okechukwu Ossai

    How to exclude duplicated data in Sum up

    Yvonne Cheng



      Do appreciate anyone could help me as I am stuck in this issue for a long time.  Workbook is attached.


      I have data source which includes duplicated data. I managed to remove duplicates with LOD in "Duration"

      The requirement is if stop time is same, remove duplicates.

      But I failed to remove duplicates in "Loss". Loss=Duration*Rate

      My ultimate goal is to build a bar chart without duplicates.


      Pls find attached workbook, thanks.