Excel Formula

Reply #13

JADELottery — Mon, 22 Oct 2018 16:08:02 GMT

the solution is quadratic for a single formula using the sum and product.

https://en.wikipedia.org/wiki/Quadratic_formula

Reply #12

JADELottery — Wed, 17 Oct 2018 13:31:18 GMT

Uh-oh, just had to ask.

Reply #11

Hydromaln7 — Mon, 15 Oct 2018 02:42:36 GMT

Nice formula Raven.

Reply #10

JADELottery — Sun, 14 Oct 2018 21:11:35 GMT

Single Cell Function?

B5, C5, D5, E5 only.

Reply #9

Bob — Sun, 14 Oct 2018 20:30:12 GMT

thank you Raven62

verygood

bob in michigan

Reply #8

Raven62 — Sun, 14 Oct 2018 20:17:37 GMT

000 0 0 0

001 0 0 1

002 0 0 2

003 0 0 3

004 0 0 4

005 0 0 5

006 0 0 6

007 0 0 7

008 0 0 8

009 0 0 9

010 0 0 1

011 0 1 1

012 0 1 2

013 0 1 3

014 0 1 4

015 0 1 5

016 0 1 6

017 0 1 7

018 0 1 8

019 0 1 9

020 0 0 2

021 0 1 2

022 0 2 2

023 0 2 3

024 0 2 4

025 0 2 5

026 0 2 6

027 0 2 7

028 0 2 8

029 0 2 9

030 0 0 3

031 0 1 3

032 0 2 3

033 0 3 3

034 0 3 4

035 0 3 5

036 0 3 6

037 0 3 7

038 0

Reply #7

Raven62 — Sun, 14 Oct 2018 19:54:12 GMT

9340 9 3 4 0 0 3 4 9

Cell B5:=(MOD($A5,10000)-MOD($A5,1000))/1000

Cell C5:=(MOD($A5,1000)-MOD($A5,100))/100

Cell D5:=(MOD($A5,100)-MOD($A5,10))/10

Cell E5:=MOD($A5,10)

Cell F5:=SMALL($B5:$E5,1)

Cell G5:=SMALL($B5:$E5,2)

Cell H5:=SMALL($B5:$E5,3)

Cell I5:=SMALL($B5:$E5,4

Reply #6

JADELottery — Sat, 13 Oct 2018 22:45:47 GMT

Pick 4

9340

Reply #5

Raven62 — Sat, 13 Oct 2018 20:10:42 GMT

Cell B5:

=MIN((MOD($A5,1000)-MOD($A5,100))/100,(MOD($A5,100)-MOD($A5,10))/10,MOD($A5,10))

Cell C5:

=MEDIAN((MOD($A5,1000)-MOD($A5,100))/100,(MOD($A5,100)-MOD($A5,10))/10,MOD($A5,10))

Cell D5:

=MAX((MOD($A5,1000)-MOD($A5,100))/100,(MOD($A5,100)-MOD($A5,10))/10,MOD($A5,10

Reply #4

Raven62 — Sat, 13 Oct 2018 19:33:15 GMT

Cell B5:

=MIN(MID($A5,COLUMN($B5)-(COLUMN($B5)-1),1),MID($A5,COLUMN($C5)-(COLUMN($B5)-1),1),MID($A5,COLUMN($D5)-(COLUMN($B5)-1),1))

Cell C5:

=MEDIAN(MID($A5,COLUMN($B5)-(COLUMN($B5)-1),1),MID($A5,COLUMN($C5)-(COLUMN($B5)-1),1),MID($A5,COLUMN($D5)-(COLUMN($B5)-1),1))

Cell D5:

=MAX(MID($A5,COLUMN($B5)-(COLUMN($B5)-1),1),MID($A5,COLUMN($C5)-(COLUMN($B5)-1),1),MID($A5,COLUMN($D5)-(COLUMN($B5)-1),1

Reply #3

Todd — Fri, 12 Oct 2018 14:07:45 GMT

Reply #2

Bob — Fri, 12 Oct 2018 13:10:56 GMT

Thank you JADE

just what we wanted works super

thanks again

bob in Michigan

Reply #1

JADELottery — Fri, 12 Oct 2018 12:59:57 GMT

Cell B5

=MIN(INT(A5/100),INT((A5-100*INT(A5/100))/10),A5-100*INT(A5/100)-10*INT((A5-100*INT(A5/100))/10))

Cell C5

=MEDIAN(INT(A5/100),INT((A5-100*INT(A5/100))/10),A5-100*INT(A5/100)-10*INT((A5-100*INT(A5/100))/10))

Cell D5

=MAX(INT(A5/100),INT((A5-100*INT(A5/100))/10),A5-100*INT(A5/100)-10*INT((A5-100*INT(A5/100))/10

Excel Formula

Bob — Fri, 12 Oct 2018 12:49:56 GMT

excel formula wanted..

ok got 3 numbers in one cell--

example in one cell A5 942

need formula to take the

smallest number and putt

it in the first cell B5 and the next

cell C5 the 2nd highest and then the 3rd

cell D5 the 3rd highest...

from SMALLEST to HIGHEST in single cells..

example again

(A5)--942------(B5)--2--(C5)--4--(D5)--9

hope we explained it right..