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
[Uploaded an Excel file]
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.