• 513K Members
• 2,252 Online
• 610K Conversations
SOLVED

## Selecting top numbers that contains fewer different digits from numbers list

Occasional Contributor

# 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

6 Replies

# Re: Selecting top numbers that contains fewer different digits from numbers list

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))`

Solution

# Re: Selecting top numbers that contains fewer different digits from numbers list

See attached file.

Play with the hurdle and see how the conditional formatting changes.

# Re: Selecting top numbers that contains fewer different digits from numbers list

Excellent!!! Thank you very very much.

# Re: Selecting top numbers that contains fewer different digits from numbers list

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

# Re: Selecting top numbers that contains fewer different digits from numbers list

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.

Thread at stackoverflow.com

# Re: Selecting top numbers that contains fewer different digits from numbers list

Yes, from my numbers list i would like select numbers  in patterns like these

 1133322 1133323 1133332 1211113 1222213 1222223 1222231 1222232 1222233 1222333 1223222

I played with the formula that you gave and could filter and select some numbers with necessary patterns. for instance i type {1;3;5;6;7} instead of  {1;2;3;4;5;6;7} and set hurdle to 1 to get numbers like 8687888.I hide two of the numbers each time and change pattern. but it take too much time in this way.

Related Conversations
Creating A Sublist
zjohnson in Excel on
5 Replies
Remove the command bar on a List Web Part
Christophe Humbert in SharePoint on
1 Replies
Adding Display Zero as Dashes to Custom Excel Number Format
emmagreen in Excel on
1 Replies