Get instant live expert help on I need help with excel sort range

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

How to sort a certain range of data in a table
Solved by O. J. in 13 mins
How to sort a column of dates when some are a range like 1910-1950 and the rest are like 1988.
Solved by O. J. in 25 mins
I built a macro to auto sort but it is not working correctly. I need the table to be sorted when values change in column A, but I need the table to be sorted by column T. Here is the macro that I wrote: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Not Intersect(Target, Range("A7:A33")) Is Nothing Then Range("A7:T33").Sort Key1:=Range("T7"), _ Order1:=xlDescending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom End If End Sub
Solved by D. U. in 20 mins
I need to sort an excel spreadsheet with multiple columns and sort it alphabetically on the column F,
Solved by V. J. in 21 mins
I need to sort a table of data by its score in the last column of the data. I will go to sort> custom sort> column = score> Sort by = values > order = smallest to largest. Excel will not rearrange the data.
Solved by Z. W. in 18 mins