Hi,

Getting desperate here..

I'm using the RANK formula to sort entries. I can get the formula to work if I manually type in the values that I want to rank. However, as soon as I replace the values with formulas, the RANK-formula returns #N/A. I have my cells formatted as number, so that shouldn't be it...