=Rank #value! (remove)

original - but returns #value!
=RANK(I16,$I$16:$I$313,0)

I would like it to return a blank instead of #value! how do I fix this function.

=IFNA(RANK(I16,$I$16:$I$313,0),"")

thank you in advance for any help.

IFNA will only trap #N/A errors, use IFERROR to trap all error types.

ty Mark for the info

=IFERROR(RANK(I16,$I$16:$I$313,0),"")

this does not work, how to correct

I’ve tried these:

=RANK(I16,IF(ISERROR(I$16:I$313),"",I$16:I$313),0)
=RANK(I16,IF(ISNUMBER(I$16:I$313),I$16:I$313,""),0)
=IF(iferror(RANK(i16,i$16:i$313,1)),"",RANK(i16,i$16:i$313,0))

still shows #value!

i try this:

=IF(ISERROR(RANK(i16,$i$16:$i$313)),"",RANK(i16,$i$16:$i$313))

does not work

How do you mean not working?

Does it still show #value, or not giving the correct result?

Make sure I16 is numeric and not text, check there is no space or '.


found what worked

=IFERROR(RANK(i16,$i$16:$i$313),"")

try
=IFERROR(RANK(i16,$i$16:$i$313)),"")