This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am attemtping to sort a list of 10 names each with a percentage associated with them from highest to lowest. Custom sort doesnt seem to work.
John
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Sorry but no - please copy the formulae out of the cells and paste them on here
Can you confirm that you don't have both the names and the numbers in the same column?
Rgds Geoff
The area I'm trying to sort highest to lowest (lets use Bill) his number seen in the previous post, ies to C50 on the same sheet. C50 gets it's data from Bills main sheet elsewhere in the workbook.
Should make no difference - what formula are you using to get the % into the column you want sorting?
Rgds Geoff
Thanks.
Will it work if the percentages are there by referencing another cell? In other words, the percentages shown in my column are taken from another column in another part of the spreadsheet.
Current challenge-
| Bill | 0% |
|---|---|
| Ricky | 23% |
| Megan | 10% |
| Amy | 5% |
| Jeanette | 7% |
| Sarah | 4% |
| Blue | 1% |
| Joanna | 3% |
| Nick | 15% |
| Rochelle | 12% |
Results when custom sorting highest to lowest, then A-Z
| Ricky | 10% |
|---|---|
| Nick | |
| Rochelle | 0% |
| Megan | 10% |
| Jeanette | 1% |
| Amy | 1% |
| Sarah | 4% |
| Joanna | 7% |
| Blue | 7% |
| Bill | 12% |
Say we have in A1 thru B10:
| Joe | 38.00% |
|---|---|
| John | 73.00% |
| James | 27.00% |
| Ralph | 77.00% |
| Larry | 17.00% |
| Moe | 68.00% |
| Curly | 20.00% |
| Boris | 50.00% |
| Rocky | 89.00% |
| Stanley | 42.00% |
hilight this area and:
Sort & Filter > Custom Sort... > Sort by Column B
will get:
| Larry | 17.00% |
|---|---|
| Curly | 20.00% |
| James | 27.00% |
| Joe | 38.00% |
| Stanley | 42.00% |
| Boris | 50.00% |
| Moe | 68.00% |
| John | 73.00% |
| Ralph | 77.00% |
| Rocky | 89.00% |
gsnu201005