Hi, I think this should be easy but I've had a long day......

I've got two columns A) Subject and B) Score. Within column A there are
multiple subjects and multiple occurences of each one 5 histories, 4 Art etc
etc. I have a student who scored 85% in history, I want to rank that student
but only against other history scores.

I'm thinking this should be an array formula but whatever I try just doesn't
work.

Thanks for your help in advance.

John