Get instant live expert help on sort excel table
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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
I need to sort a table automatically as its values are updated. On the attached file, go to the prediction sheet. The table Group A I want to automatically sort based on points (as the scores on the left change, the table should automatically sort).
Thanks
Solved by V. Q. in 20 mins
Sort by Pivot Table Row Grand Total column
Solved by I. E. in 18 mins
I need to sort a pivot table in the "Rows" quadrant. In my Pivot Table the only row that allows me to sort is the first column in the Rows Quadrant. Ideally, I need to sort on all of the rows.
Solved by T. A. in 15 mins
Convert the data to a table, name the table Inventory, and apply the Table Style Medium 19.
Remove duplicate records.
Sort the table by Make in alphabetical order, add a second level to sort by Year Smallest to Largest, and a third level to sort by Sticker Price Smallest to Largest.
Repeat the field names on all pages.
Change page breaks so each vehicle make is printed on a separate page.
Solved by E. E. in 28 mins