Formula Help

[ststern45]

Need help with a formula:

I have numbers ranging from 000000 through 999999

The numbers can be grouped:

Can be in any order.

123456 = No Match = 0

999999 = sextuplet = 6/1

999991 = quintuple/single = 5/1 (1 = no repeats)

999912 = Quadruple/singles = 4/1 (1 = no repeats)
999911 = Quadruple/double = 4/2 (2 = double)

999888 = Triple/Triple = 3/3 (3 = triple/3 = triple)
999123 = Triple/Single = 3/1 (3 = triple/1 = singles)
999122 = Triple/double = 3/2 (3 = triple/2 = double)

998877 = Double/Double/Double = 2/2/2 (2 = double/2 = double/2 = double)
998812 = Double/Double/Single = 2/2/1 (2 = double/2 = double/1 = singles)
991234 = Double/Single = 2/1 (2 = double/1 = singles)

Is their a way to classify each of the above into separate results such as "0", "6/0", "5/1", "4/1", etc.?

Thank you in advance!!

 

[mole999]

Re: Forlmula Help

just a question, 900009 how does that get treated

 

[ststern45]

Re: Forlmula Help

900009

Treat in smallest form:

000099

= Quad/Double

 

[mole999]

Re: Forlmula Help

That's sort of what I thought might happen, but I wasn't sure from what was published