Excel - COLUMN Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

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

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc