RussChilds
Active Member
- Joined
- Jun 8, 2007
- Messages
- 267
Hi All,
I'm using the RANK formula:
=RANK(BL2,$BL$2:$BL$186,0)
Some students do not have a grade so their cell is blank. How do I get the formula to ignore the blank cells?
Many thanks,
Russ
I'm using the RANK formula:
=RANK(BL2,$BL$2:$BL$186,0)
Some students do not have a grade so their cell is blank. How do I get the formula to ignore the blank cells?
Many thanks,
Russ