# Sorting and re-sorting in another cell range

#### ststern45

##### Well-known Member
P1
0 5
1 0
2 1
3 14
4 4
5 17
6 2
7 3
8 27
9 8

Cell range G3 through G12 has numbers 0 through 9

Cell range H3 through H12 has their corresponding numbers

What I would like to do is sort these numbers in ascending order and place them in cell range A3 through B12.

Thank you,

Steve

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
How it should look

So the chart should look like this starting in cell A3 through B13:

8 27
5 17
3 14
9 8
0 5
4 4
7 3
6 2
2 1
1 0

Thanks,

Steve

Morefunc formula??

Is their a Morefunc formula that would solve this?

Thanks

Steve

Replies
7
Views
251
Replies
14
Views
613
Replies
16
Views
1K
Replies
17
Views
609
Replies
2
Views
255

1,214,264
Messages
6,118,563
Members
448,837
Latest member
Josephjet

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