Ranking multiple criteria without duplicates

[annabeladams]

I understand that this question has been answered before, but I am running into ongoing problems with the formulas I have tried so far.

In the following data set, I want to rank highest to lowest scores in column A. Where there are ranked duplicates, I want to apply the secondary criteria in coloumn B, but here, the higher the number the worse the performance. If there are still duplicates, I then want to apply the third criteria in column C. Here, again the lower the number the better performance. I would not like any duplicates in the data set. Any advice would be greatly appreciated!

 

[jkpieterse]

If you want to learn PQ I highly recommend the book "M is for Data Monkey" by Ken Puls et al.