help in excel, detect the largest and smallest digit of pick3 zero is the smallest digit *

help in excel, detect the largest and smallest digit of pick3 zero is the smallest digit
* example
456
489
156
014
at 456, the double of the position is 1.3
we have three positional doubles
* 1,2,1,3, 2,3 possible to be the smallest and largest
* inside pick3, also the macro needs to make the location to be the first or second of the pair
* ex
489 = 1.3, smallest digit in the first position of the pair and largest in the 2nd position
but in this example =
971 = 1.3 the largest (9) digt is in 1st position
* need someone in excel

hello,MEH, is lottery pick3
https://www.excelforum.com/attachmen...1&d=1582846995

hello on the pick3 list, it’s just an example every week I’ll put new draws the macro has to do automatically, when there are twin
* 00,11,22,33,44,55,66,77,88,99, the macro does not
* ex = 448, or 551 ...

objective = locate the smallest and largest digit of pick3, within the positions consequently
* will have the 3rd as being average

ok, kaper, very good dissection work, from the smallest major pattern in pick3, great work in excel, if i know the positions of the major and minor pair,
* I will have more chances of predicting pick3 in the 720 pick3 formations, thanks for the hard work