Sort multiple columns with numbers

[falcios]

Is there a way to select and sort all the numbers at one time? Right now I have to manually sort each column.

I inserted a table but that didn't work.

Any idea how I can select and sort all the data?

Thanks in advance.

 

[Saba Sabaratnam]

if you are using office 365, you could use SORTBY function to sort your data dynamically without manual intervention.

My data is highlighted in yellow.

I enter the headings and then use the following formula to sort By Sales (largest to smallest - 1) and then Costs


=SORTBY(A2:C12,B2:B12,-1,C2:C12,-1)

Kind regards

Saba

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I also suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

From your description, you are wanting to sort every column individually. If that is so, then I would suggest a macro. This should sort each column, starting from column B. Test with a copy of your workbook.

Sub Sort_Columns()
  Dim col As Long
  
  Application.ScreenUpdating = False
  For col = 2 To Cells(1, Columns.Count).End(xlToLeft).Column
    Columns(col).Sort Key1:=Cells(2, col), Order1:=xlAscending, Header:=xlYes
  Next col
  Application.ScreenUpdating = True
End Sub