# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I've made a table with assessment results for a class. I'd like to organise the list according to scores but when I choose 'sort ascending' it only sorts the scores. I need to link to names in column A with the scores in column B and then sort. How do I do that?
Solved by K. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 20/06/2018 - 09:29
Hello
Excelchat Expert 20/06/2018 - 09:29
come to Got It Pro?
User 20/06/2018 - 09:29
Hi
User 20/06/2018 - 09:29
Have you seen my question?
Excelchat Expert 20/06/2018 - 09:29
Yes, I'm so glad to assist you today
Excelchat Expert 20/06/2018 - 09:29
Yes,
User 20/06/2018 - 09:30
great
Excelchat Expert 20/06/2018 - 09:30
Can you share your file to us to do the resolution for you?
User 20/06/2018 - 09:30
Not sure how to share the file.
Excelchat Expert 20/06/2018 - 09:31
Please click the paper clip beside your chat area to attach the file of yours
User 20/06/2018 - 09:31
I have done a little example file (mel, dave and bea). If you show me on that, I'll be able to do it on my bigger file.
Excelchat Expert 20/06/2018 - 09:31
Sure
Excelchat Expert 20/06/2018 - 09:31
Okay let's show you how at the Document preview shown at the right side of your screen
User 20/06/2018 - 09:32
Great
User 20/06/2018 - 09:34
Hello?
User 20/06/2018 - 09:35
I hae to go to help a kid at my school. Maybe catch you when I get back?
Excelchat Expert 20/06/2018 - 09:36
First, select the range from A1 to B4
Excelchat Expert 20/06/2018 - 09:36
Then click menu "Data" then select "SORT RANGE"
Excelchat Expert 20/06/2018 - 09:37
Then, A box will pop-up for sorting
Excelchat Expert 20/06/2018 - 09:37
Have you tried this method?
Excelchat Expert 20/06/2018 - 09:37
Hello
Excelchat Expert 20/06/2018 - 09:38
Please try the steps above in sorting, ascendingly based on your column B (scores) as required
Excelchat Expert 20/06/2018 - 09:38
Have you seen the result now?
Excelchat Expert 20/06/2018 - 09:42
Excelchat Expert 20/06/2018 - 09:42
Please refer with the screenshot above with regards to the pop up box for forting the score linked with its corresponding name
Excelchat Expert 20/06/2018 - 09:44
Please note that a box before the "Data has header row" must be check. This will link the arrangement when the score are being sorted. Means, a row will come together wherever their position goes.
Excelchat Expert 20/06/2018 - 09:45
Then, select the sort by: "Score" to sort accordingly either ascending or descending
Excelchat Expert 20/06/2018 - 09:46
I think you got it how to be sorted now. Please let me know for any concern while sorting?
Excelchat Expert 20/06/2018 - 09:47
Once more, is there anything else you want to know regarding this issue?

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.