Most valuable professional
  • Hot Topics

Excel HELP: How to rank.avg that excludes cells with error.

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. A STUDENTS A B C E F G

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of May 12, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel