0 Replies Latest reply on Oct 17, 2017 6:31 AM by Josipa Grebenar

    How to identify the same items within a category?

    Josipa Grebenar

      Hi to all of you!

       

      I am trying to make a calculation which would help me to find the same items within one broadcast, and give the value only once.

      For all other items (if available), it should return null value. (Rows marked in red / green / yellow should have a null value).

       

      Basically, it should say: if the Channel, Name of the Broadcasts, Broadcast start Time, Home & Away are the same, then return the value (AUD / RTG% / SHR%) only for the first row.

       

      RTG.PNG

       

      Packaged workbook is attached, as well as the source excel file with the example columns (of how the data should look like in the end).

       

      Thanks!

       

      Josipa