# Hi everyone! Can excel do like this?

#### apasaja

##### New Member
HI ALL, CAN EXCEL DO LIKE THIS?

SORT ASCENDING IN BOX.

FROM

 A B C D 1 7 5 0 2 2 3 0 8 1 3 5 6 6 2 4 0 0 9 5 5 1 0 0 7

<tbody>
</tbody>

TO

 E F G H I = 0257 = 0138 = 2566 = 0059 = 0017

<tbody>
</tbody>

WHAT IS THE FORMULA?

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### Andrew Poulsom

##### MrExcel MVP
Welcome to MrExcel.

Try in F1 copied down:

=MIN(A1:D1)&SMALL(A1:D1,2)&SMALL(A1:D1,3)&MAX(A1:D1)

#### vinodmalempati

##### New Member
Try This Formula -

=SMALL(B2:E2,1)&SMALL(B2:E2,2)&SMALL(B2:E2,3)&SMALL(B2:E2,4) Copy down all cells.

#### apasaja

##### New Member
it's says #VALUE! sir any suggestion?

#### apasaja

##### New Member
MrExcel MVP & vinodmalempati

it's says #VALUE! huhuhu

#### Michael M

##### Well-known Member
Are they actual numbers in the cells or text ??
Andrews solution works fine for me !

#### apasaja

##### New Member
format the actual in cell is the number..

#### Michael M

##### Well-known Member
Ok, have a look at my tag and download the HTML Maker to post a sample of the data and the associated formulae, back here.

#### Useful

##### Active Member
Hi everyone!

like this? (array formula with CSE)
=TEXT(SUM(SMALL(A1:D1,{1;2;3;4})*{1000;100;10;1}),"0000")

Replies
0
Views
83
Replies
6
Views
351
Replies
3
Views
91
Replies
8
Views
229
Replies
2
Views
157

1,195,936
Messages
6,012,393
Members
441,695
Latest member
MickRobertson

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back