Good day! I am ranking my students final grade. But it gives me a #DIV/0! error. My formula is =RANK.AVG(C2,C$2:C$9). What I wanted is that A and F will rank 2.5 (because they occupy the 2nd and 3rd place) and B, C, and E will rank 5 (for places 4, 5 and 6). Another thing is that, I wish that the rounded grade will be the basis of ranking. Please help. I would like to say THANK YOU in advance for those who can help me. Below is a sample of my worksheet.
This question generated 11 answers. To proceed to the answers, click here.
This thread is current as of May 12, 2015.