Excel Help Plese

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!

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

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

Try this

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

change cell range to yours

1. You don't need VBA.
2. Median won't work for Pick 4.

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.

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

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!

good stuff carbob...

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

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 A11 enter =value(mid(a9,2,1)

in A12 enter =value(mid(a9,3,1)

your result is now a number again with each digit in its own cell.

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

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

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!

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

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

Hi, Raven:

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