Excel Help Plese

Reply #14

lottoburg — Fri, 01 Jun 2012 01:54:21 GMT

Hi, Raven:

I sent a PM to you just now but your Inbox is full.

Reply #13

LottoBoner — Sun, 20 May 2012 21:45:44 GMT

ok i just tried it...and it worked...so i guess i will delete my posts...or i will just leave them up so everybody can see what a bone head i can be!!!

simple...=bc1+10

wow!! I am an excel guru too

Reply #12

LottoBoner — Sun, 20 May 2012 21:41:10 GMT

actually now that i look at it i can use a simple additive formulas...

10 + 3

20 + 2

30 + 1

DUH!!!

Well i guess i just want to be sure its that simple...

Reply #11

LottoBoner — Sun, 20 May 2012 21:38:56 GMT

I am trying to create a formula with the following results:

Col. A Col. B Col. C Col. D Col. E Col. F

3 2 1 13 22 31

9 3 9 19 23 39

8 7 6 18 27 36

I want to take numbers from 3 cells and convert them. I need a formula to convert the three cells into differnt values as shown above.... Can anyone help? Please. Thanks to all you Excel Gurus

Reply #10

LottoBoner — Sun, 20 May 2012 21:35:51 GMT

thanks for the reply philight...i have not tried it yet but i made this post as a favorite so when it gets buried i can still find it...i dont normally do that type of analysis but i DO have a question on how to convert cells...using 10 20 30 as place holders...for example..

Reply #9

Raven62 — Thu, 17 May 2012 22:18:59 GMT

Cell D2: =SMALL($A2:$C2,1)*100+SMALL($A2:$C2,2)*10+SMALL($A2:$C2,3)*1

Reply #8

phileight — Thu, 17 May 2012 00:39:11 GMT

Carbobs method causes EXCEL to think that the result is text, not a number. for most purposes this is not a problem, just something to be aware of. it does have the adavantage that the leading 0 is displayed. if it was a number the leading 0 would not be displayed.

Lotoboner to convert this back to a 3 digit number, lets assume the result is in A9, and you want your 3 digits in A10,11,and 12, it could be anywhere you just have to change the references.

in A10 enter =value(mid(a9,1,1)

in... [ More ]

Reply #7

LottoBoner — Wed, 16 May 2012 22:21:24 GMT

good stuff carbob...

now how do you take the new results and put each digit into new cells for filtering

Reply #6

BevsPicks2 — Wed, 16 May 2012 20:06:46 GMT

Take your bow! You are an Excel Guru! This was very simple and easy to follow. I am now going to have to reprogram a boat load of stuff but this certainly makes my life easier! You are the stuff

Reply #5

BevsPicks2 — Wed, 16 May 2012 20:00:59 GMT

thanks Cabob...I'll try this. Will let you know how it turns out.

Reply #4

BevsPicks2 — Wed, 16 May 2012 19:59:46 GMT

Thanks a million time*treat. I'm willing to try anything. I've created a cumbersome macro and it takes a long time to process. It handles only small amounts of data efficiently.

Reply #3

SergeM — Wed, 16 May 2012 17:27:21 GMT

1. You don't need VBA.

2. Median won't work for Pick 4.

Reply #2

CARBOB — Wed, 16 May 2012 17:13:57 GMT

Try this

=MIN(a19:c19) MEDIAN(a19:c19) MAX(a19:c19)

change cell range to yours

Reply #1

time*treat — Wed, 16 May 2012 17:01:07 GMT

I thought you'd need a macro for this since the entry numbers won't be in a fixed order.

But, it seems if you're willing to take an intermediate step ...

https://www.lotterypost.com/thread/114945

Excel Help Plese

BevsPicks2 — Wed, 16 May 2012 14:51:49 GMT

I am trying to create a formula with the following results:

Col. A Col. B Col. C Col. D Box Order(Ascending)

3 2 1 123

9 3 9 399

8 7 6 678

I want to take numbers from 3 cells and combine them in ascending order. I need a formula in column D that will display the numbers as listed above. Can anyone help? Please. Thanks to all you Excel Gurus