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,

      Regards,

      Bikash