Ranking in categories

Hi there,

I wondered if you could help.

In columns M-O I'm trying to rank the average P1-P5 score by category. e.g. I would like the scores in column K to be ranked for all the names in column M.
In column N, I would only like to rank scores in column K according to their "MD" (Column C), and similar for "RD" in Column O.

I hope this makes sense... sorry if confusing... and thank you!