separate the last digit into threes, then detect one of the 6 largest patterns.

[jorel]

separate the last digit into threes, then
detect one of the 6 largest patterns
* minor and medium
* where
* largest is 3
average = 2
smaller = 1
example 453 =
the digit 5 in the 2nd position is the largest then it is 3
3rd digit is smaller = 1 and 1st digit is average =
2
then 453 = 231
https://www.excelforum.com/attachmen...1&d=1569184145

[jorel]

three patterns 123
smaller = 1 132
medium = 2 213
greater = 3 231
312
321

[jorel]

smaller=1
medium=2
greater=3
6 paterns in 100%
123
132
213
231
312
321

[jorel]

hello please!!!

[JeteMc]

I believe that the following will do what you want:
1. The digits are separated using: =MOD(A10,10)
2. The patterns are assigned using:

Please Login or Register  to view this content.

Let us know if you have any questions.

[Rick Rothstein]

smaller=1
medium=2
greater=3
6 paterns in 100%
123
132
213
231
312
321

Question: What if there are ties?

For example, what would be the pattern for these...

225

733

666

[jorel]

hello JETE, excellent, great job, perfect, on the question, is few
* times that happens in the formula would be the value of
* False (O) but this event is 3% against 97%, so it was very good, thanks jete

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.