• Find Dupes in a sheet (Excel 2003)

    Author
    Topic
    #439647

    Hi all

    I have a workbook which imported 54000 rows of data from another application, there appear to have many duplicated data.
    I want to remove all dupes for an account based on the information on the last column which is Product and keep the Unique
    items.

    I have attached a sample which shows what I want

    thanks in advance

    Viewing 0 reply threads
    Author
    Replies
    • #1051043

      Assuming 2003 is the same as 2000:

      Click on any cell in your data.
      Go to Data / Filter > Advanced Filter.

      The window that opens from there is self explanatory.

    Viewing 0 reply threads
    Reply To: Find Dupes in a sheet (Excel 2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: