Question description:
This user has given permission to use the problem statement for this
blog.
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 14 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
27/04/2018 - 06:21
Welcome to got it pro
Excelchat Expert
27/04/2018 - 06:21
I understand you want help with sorting.
Excelchat Expert
27/04/2018 - 06:21
Can you please send me the file?
User
27/04/2018 - 06:22
can you see the excel online page that i just put data in?
Excelchat Expert
27/04/2018 - 06:23
Yeah.
User
27/04/2018 - 06:23
for some reason i cannot get excel to sort this data by the score column from smallest to largest
Excelchat Expert
27/04/2018 - 06:24
I have just performed a sort here. The file is sorted now from smallest to largest.
User
27/04/2018 - 06:26
did you just do a custom sort of the data? do you know why i am running into problems trying to do the sort?
Excelchat Expert
27/04/2018 - 06:27
No, I just did normal sort on the preview window. And to answer the 2nd question, I need to look at the original excel file.
Excelchat Expert
27/04/2018 - 06:27
Can you send it to me?
User
27/04/2018 - 06:30
for privacy concerns I cannot. I am able to resort it using the same method i was trying in excel so im unsure why it wont work for me. you have been helpful though, I think im going to copy the data into an excel online doc and try to edit it from there.
Excelchat Expert
27/04/2018 - 06:30
I understand the security concern.
Excelchat Expert
27/04/2018 - 06:34
Thanks for choosing got it pro.
Excelchat Expert
27/04/2018 - 06:34
Have a great day ahead!
User
27/04/2018 - 06:34
it is working in excel online, must be a glitch with my mac or something. Thank you for your help! have a good one!
Excelchat Expert
27/04/2018 - 06:35
please close the chat session now.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.