+ Reply to Thread
Results 1 to 3 of 3

Sorting out all repeat numbers

  1. #1
    Forum Contributor
    Join Date
    11-13-2010
    Location
    Warren, Michigan
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    307

    Sorting out all repeat numbers

    Could anyone explain why the code I'm using is only including repeat numbers with "0" in the number and miss 5 other repeat numbers (highlighted in magenta)?

    See sample...
    Attached Files Attached Files
    Last edited by khank; 03-24-2011 at 07:37 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Sorting out all repeat numbers

    Is there any reason as to why the likes of 022, 066, 077 are not highlighted ?

    Assuming the above to be an oversight and return of 902 an error then a more straightforward approach would be to compare the characters:

    Please Login or Register  to view this content.
    The above would highlight triples also - if that's not required the above can be altered (revert to addition of equality tests and test for result of 2)

    The existing method fails as it assumes a string containing duplicate digits will either be a multiple of 11 or less than 11 (001-010)

  3. #3
    Forum Contributor
    Join Date
    11-13-2010
    Location
    Warren, Michigan
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    307

    Re: Sorting out all repeat numbers

    It was late and I was extremely tired -- just missed them.

    Thanks the code works great. Have a great day.

+ 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