Hi there, thank you for responding so quickly, really appreciate it.
I don't think that works, that formula returns a name but I was hoping numbers would appear in column M-O.

So for row 3 column N, I wanted to know what rank Alan Francis is within Romeo Cox's MD category. Similarly, in column O I wanted to know what rank Alan Francis is within Kellie Lowe's 'RD' category.

You'll notice there are 4 names which are within the RD category "Kellie Lowe"... so I'm after a rank of 1-4 between Alan Francis, Ida Velazquez, Jannie Becker & Carmella Pope.

I hope this makes a little bit of sense!!