Results 1 to 2 of 2

Thread: Advanced Duplicate Removal?

  1. #1

    Advanced Duplicate Removal?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a bit of an issue - We have an inventory list that was duplicated. Normally, you could just do 'remove duplicates' and everything would be fine - however, we have several duplicate entries to begin with, so , like below:

    LOCATION, BRAND, ITEM DESC
    1, A, TOY
    1, A, TOY
    1, B, HAIR DRYER
    1, B, HAIR DRYER
    1, B, HAIR DRYER
    1, B, HAIR DRYER
    1, C, LAPTOP
    1, C, LAPTOP
    1, C, LAPTOP
    1, C, LAPTOP
    1, C, LAPTOP
    1, C, LAPTOP

    We should have 1 of A, TOY. 2 of B, HAIR DRYER, and 3 of C, LAPTOP
    Is there a way to remove HALF the entries based on criteria? (Such as Container Number?)

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,830
    Articles
    0
    Excel Version
    O365
    Where does container number come into play?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •