Ranking Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
John,

=1+SUMPRODUCT(($A$2:$A$100="History")*($B$2:$B$100>B2))

This gives ties the same (highest) rank.

HTH,
Bernie
MS Excel MVP
 
Better would be

=1+SUMPRODUCT(($A$2:$A$100=A2)*($B$2:$B$100>B2))

Then filter your list based on column A to only show one subject at a time.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ties using Rank Function 3
How to finding student Rank and How to upload bulk marks of each student at a time. 1
descending order of a series of data 8
Ranking sometimes shows ties and sometimes not 3
RANK sublist 6
Ranking problem. 6
Conditionally summing cells based on conditions in other rows 3
Reverse ranking 1

Back
Top