Forum Discussion
Solved
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...
See attached file.
Play with the hurdle and see how the conditional formatting changes.
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))