Remove Duplicates wont work

  • Well ... if there are duplicates in the Pivot table ... it does mean your original data might probably need some cleaning to get rid for example of blanks, spaces, etc ...


    Are you getting this list from a mainframe download ...?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Re,


    Based on your test file ...


    6'337 records
    5'523 OEMs appear once
    634 OEMs appear twice
    168 OEMs appear three times
    12 OEMS appear four times


    i.e. a total of 5'899 UNIQUE OEMs (5'523+317+56+3)


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Here is a VBA solution that I believe will remove your duplicates.