+ Reply to Thread
Results 1 to 2 of 2

List Duplicates (Don't Remove)

Hybrid View

Imran688 List Duplicates (Don't Remove) 08-15-2012, 08:06 AM
NBVC Re: List Duplicates (Don't... 08-15-2012, 08:13 AM
  1. #1
    Registered User
    Join Date
    07-27-2012
    Location
    London
    MS-Off Ver
    excel 2010
    Posts
    6

    List Duplicates (Don't Remove)

    Hi guys,
    I am looking for a way to find and separate the duplicates in the inventory. It turned out the some of books in my stores inventory have been listed more than once on ebay. That is causing pricing issues and mismanagement of inventory.
    Now, i have a file which contains ItemIDs (Unique) in one column and ISBN (may not be unique) in 2nd column. The only way to remove the duplicated books is to provide their ItemID. How can i find and separately list duplicated ISBN (Remember ItemID is unique for even duplicated ISBN). There must be one ISBN value left in the list because i just want to remove duplicated value, not the original one.
    Please review the attached file. Thank you very much
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: List Duplicates (Don't Remove)

    In C3 enter helper formula:

    =IF(COUNTIF(B$3:B3,B3)=2,COUNT(C$1:C1)+1,"")

    copied down

    Then in another column, enter:

    =IFERROR(INDEX(B:B,MATCH(ROWS($A$1:$A1),$C:$C,0)),"")

    copied down
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1