Ascending Order
 

Can someone show me the formula to solve my problem?

Cell A1=3
Cell B1=4
Cell C1=2

in cell D1=a1&b1&c1 which give me 342 but I like it to show i
ascending order 234.

What formula should be in cell D1?

Thanks
Michae

--
Message posted from http://www.ExcelForum.com

Ascending Order
 

Hi
one way (if you only have these three cells):
=MIN(A1:C1) & LARGE(A1:C1,2) & MAX(A1:C1)

--
Regards
Frank Kabel
Frankfurt, Germany


Can someone show me the formula to solve my problem?

Cell A1=3
Cell B1=4
Cell C1=2

in cell D1=a1&b1&c1 which give me 342 but I like it to show in
ascending order 234.

What formula should be in cell D1?

Thanks
Michael


---
Message posted from http://www.ExcelForum.com/

Ascending Order
 

Michel,

Try =SMALL(A1:C1,1)&SMALL(A1:C1,2)&SMALL(A1:C1,3)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

"Michael168 " wrote in message
...
Can someone show me the formula to solve my problem?

Cell A1=3
Cell B1=4
Cell C1=2

in cell D1=a1&b1&c1 which give me 342 but I like it to show in
ascending order 234.

What formula should be in cell D1?

Thanks
Michael


---
Message posted from http://www.ExcelForum.com/

Ascending Order
 

Tr
=Small(A1:C1,1)*100+ Small(A1:C1,2)*10 + Small(A1:C1,3)

Assumes that cells A1,B1 & C1 contain a single digit

Small(A1:C1,1) & Small(A1:C1,2) & Small(A1:C1,3) ' this gives you the correct sequence as tex