Let's say I have a table as above and I would like to perform sorting/ranking based on the following conditions:Student Total Result GPC A 398 PASS 1.2 B 341 PASS 1.6 C 396 PASS 1.8 D 402 FAIL 1.6
Sort by "Result" descending
Then sort by "GPC" ascending
Finally sort by "Total" descending
Hence the end result would be like this:
How can I do the sorting above in excel? I had tried to use RANK in the formula but it can only cater to one condition.Student Ranking A 1 B 2 C 3 D 4
Welcome to the forum.
Data > Sort
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Thanks for the welcome.Originally Posted by shg
I need to do that using formula. And Data > Sort does not work well when you have merged headers too.
Hello omnri,
Welcome to the Forum!
You should post your workbook. Seeing the layout, formatting, formulae, and any VBA code, will guarantee a working solution. A lot of time will also be saved by eliminating guesswork and a lot questions can be answered just by workbook itself.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks