Log in

View Full Version : Formula to rank data where two values are the same



Howardc
03-17-2013, 11:56 AM
I have a spreadsheet with various marks. I have tried to set up a formula to rank the marks, but where two marks are the same i get the same student name-see formulas B24:D28

It would be appreciated if you could assist in correcting the formula so that if two diffrent students get the same mark, it will display their names as well as there student numbers

Admin
03-17-2013, 01:34 PM
Hi

PFA.

Howardc
03-17-2013, 06:07 PM
Thanks for the help, much appreciated