What is the formula to use that when ranking and two numbers are the same it
will just assign it the next numerical value. I am
using"=RANK($C49,$C$49:$C$62,1)" some cells automatically will go to the next
number, however most will not. I am throroughly confused!!!