16 Replies Latest reply: Jun 18, 2011 10:12 AM by Clever Anjos RSS

    remove duplicates while taking sum.

      Hi All,

      Hope you had a great weekend.


      Here I am with a new set of problem.


      I have attached an excel with this email with the data set.


      The problem is

      I have duplicate item Id. So how do I remove the duplicates?. My final aim is to total the Design - Create date and count the unique Item Id and then find the average.

      But here because of the duplicate item ID, I also have extra amount in my total. How do i remove the duplicates and there influence in the total.


      please help,


      Thanks a lot,