Excel question

[Thomas. PLease.]

I have some formula generated lists of numbers I want to rank.

Must these be hardcoded values for me to do so?

Is anyone aware of a way I can rank the output of the formula in that particular cell?

Doing so at the moment with the normal Rank formula just gives me an #N/A

 

[Thomas. PLease.]

Edit:

Nvm, countif seems to do the job