+ Reply to Thread
Results 1 to 3 of 3

Find Duplicate Number

  1. #1
    Registered User
    Join Date
    10-17-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    12

    Find Duplicate Number

    Please Help!
    I got these codes of running duplicates but it seems that it only recognizes TEXT but i am looking for duplicates according to Number/Series.
    I have an attached sample.
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Find Duplicate Number

    Hello candyfreak,

    it only recognizes TEXT but i am looking for duplicates according to Number/Series.
    I find all in order, and cannot see any duplicated text or numbers that are not listed on the "Duplicated Report".
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    10-17-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Find Duplicate Number

    Thankyou for your reply Winon..

    if duplicate. ast the "number of duplicates" column will count and list down how many times the number or series appears. and if there is no duplicate.. i dont want it to appear in the Duplicate tab..
    For instance, in 1st sheet Column A I have 123 and in the 2nd sheet Column A I have 123
    Then, in the Duplicate Report will post 123 and the agent/s could not be the same and how many time it appears like "2"
    So, if 123 doesnt have any match or duplicates in the next sheet then don't let it appear at the duplicate report.
    Sorry if it's confusing.

+ 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