Dear,
I need help creating a formula which can detect repeated numbers in a string.
The rule is: If a number appears more than 3 times, mark as "INCORRECT ACCOUNT NUMBER"
Example:
NL15ABNA0123456789
NL15ABNA0123451234
NL15ABNA0123456789
NL15ABNA0424456784 INVALID ACCOUNT NUMBER (Number "4" appears more than 3 times)
with Power Query
is that what you want?
Index AccNum Note NL15ABNA0123456789 NL15ABNA0123451234 NL15ABNA0123456789 NL15ABNA0424456784 INVALID ACCOUNT NUMBER NL15ABNA0123252782 INVALID ACCOUNT NUMBER NL15ABNA0123252787 NL15ABNA0333253332 INVALID ACCOUNT NUMBER
Last edited by sandy666; 03-18-2023 at 02:40 PM.
Formula alternative:
Formula:
Please Login or Register to view this content.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi Sandy, yes that is correct.
Re: Repeated Number in string
as I said this is a Power Query - no formula, no vba
if you add more Account Numbers just right click on the green table and select Refresh
Glenn I am amazed! I cannot thank you enough. That formaula is just amazing!
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks