I want to remove " 1 " from a ranked column.
Scores are recorded in column A and using the formula " =RANK(A3;$A$2:$A$17:1) in column B3, these scores are change to "positions" in column B where the lowest scores get highest position.
The problem is that when no score is recorded, a zero is put in column A. This equates to the lowest score and in column B, its given a position of " 1 ".
Is there a better formula to use or edit the formula that I have used.
Many thanks from a complete newbie.
Bookmarks