Sort Values

[CARBOB]

Need a formula in col F to sort values in Col's B:D, low to high. Examples in Col F.

Excel Workbook
	A	B	C	D	E	F
17	06/27/11	4	9	9	499	499
18	06/26/11	6	5	6	656	566
19	06/25/11	1	7	6	176	167
SKIPSUMS

Excel 2007

Cell Formulas
Range	Formula
E17	=B17&C17&D17
E18	=B18&C18&D18
E19	=B19&C19&D19

 

[JackDanIce]

Formula can't sort values, why not highlight the whole area and then select the sort option from the data menu and apply to column E?

 

[moonfish]

Put this in F1 and copy it down:
=min(a1:c1)&median(a1:c1)&max(a1:c1)

 

[hiker95]

moonfish,

Nicely done.


CARBOB,

Here you go.

Excel Workbook
	A	B	C	D	E	F
17	6/27/2011	4	9	9	499	499
18	6/26/2011	6	5	6	656	566
19	6/25/2011	1	7	6	176	167
SKIPSUMS

 

[CARBOB]

Thank you very much!!!

Put this in F1 and copy it down:
=min(a1:c1)&median(a1:c1)&max(a1:c1)