How to perform ranking based on several conditions?

**omnri** · 09-10-2011, 11:43 AM

Please Login or Register  to view this content.

Let's say I have a table as above and I would like to perform sorting/ranking based on the following conditions:

Sort by "Result" descending
Then sort by "GPC" ascending
Finally sort by "Total" descending
Hence the end result would be like this:

Please Login or Register  to view this content.

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.

**shg** · 09-10-2011, 12:15 PM

Welcome to the forum.

Data > Sort

**omnri** · 09-10-2011, 12:23 PM

Originally Posted by shg

Welcome to the forum.

Data > Sort

Thanks for the welcome.

I need to do that using formula. And Data > Sort does not work well when you have merged headers too.

**Leith Ross** · 09-10-2011, 02:33 PM

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.