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)),"")