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...
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...
Last edited by khank; 03-24-2011 at 07:37 AM.
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:
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)![]()
Please Login or Register to view this content.
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)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
It was late and I was extremely tired -- just missed them.
Thanks the code works great. Have a great day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks