Forum Discussion
Selecting top numbers that contains fewer different digits from numbers list
Hello.How can I select top numbers from my numbers list that contains less different digits ?for example there are 5 different numbers 3333333,3330333,3330633,3330623,3330628.How can i automatically select top 2 number (3333333 and 3330333) that contains fewer different digits?Thanks
See attached file.
Play with the hurdle and see how the conditional formatting changes.
6 Replies
See attached file.
Play with the hurdle and see how the conditional formatting changes.
Now i have got numbers list that contains only 2 and 3 unique digits.Can we add another parameter to this file to be able to select only some digit combinations from these numbers that contains 2-3 unique digits?For example when i add this combination 1133322 to the parameter,the numbers in this combinations (like 66888444,5577799,3366688)can be selected automatically.I have got cominations list ,i would like to add my combinations list to that paramater,not only one combination.Thank you
You want to match patterns?
I don't think that is possible with formulas. Maybe with VBA. But that's not my field of expertise.
Excellent!!! Thank you very very much.
Hi
To count unique digits for six digit numbers:
=MMULT({1,1,1,1,1,1,1},--(FREQUENCY(--MID(A1,{1;2;3;4;5;6},1),--MID(A1,{1;2;3;4;5;6},1))>0))
