Help with sorting rows of numbers from small to large numbers

MrsFrankieH

Active Member
Joined
Mar 25, 2011
Messages
323
Office Version
  1. 365
Platform
  1. Windows
Hello all,

My operating system is Windows 10.
Samsung Tablet

Could someone please help me with a formula to sort rows of numbers in numerical order? I was told that my Excel had "limitations" and that's why I can't get the results I need. As you can see, I put a couple of sorted rows in cells on the right. The cells on the left are not sorted. I know if anyone can do it, most of you can. Thank you in advance.







MM.xlsx
ABCDEFGHIJKLM
1DateNumber 1Number 2Number 3Number 4Number 5
2Tuesday, June 7, 2022413445340434404153
3Friday, June 3, 202216112248591116224859
4Tuesday, May 31, 2022156364641
5Friday, May 27, 2022534035414
6Tuesday, May 24, 20223563668
7Friday, May 20, 20224033606959
8Tuesday, May 17, 2022412421765
9Friday, May 13, 20221144654341
10Tuesday, May 10, 20221519706120
11Friday, May 6, 20221652213370
12Tuesday, May 3, 20225727351915
Sheet1
 
Last edited:

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,216,743
Messages
6,132,464
Members
449,729
Latest member
davelevnt

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top