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

Reply #4

Todd — Fri, 28 Feb 2020 15:17:34 GMT

No, Excel is not math. It is software. Many people use Excel for things that have nothing to do with math, and in fact this particular thread's topic about using Excel has nothing to do with math.

If there is a question about a math formula being developed in Excel (or any other software), that would be something for the math forum.

Reply #3

nibor200 — Fri, 28 Feb 2020 15:13:35 GMT

@Todd,

Shouldn t Excel questions be in Mathematics forum.?

Thanks,

Ed S.

Reply #2

Todd — Fri, 28 Feb 2020 01:42:16 GMT

Reply #1

dr san — Fri, 28 Feb 2020 00:08:59 GMT

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 ...

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

dr san — Thu, 27 Feb 2020 23:27:55 GMT

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... [ More ]