=Rank #value! (remove)

original - but returns #value!

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


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


this does not work, how to correct

I’ve tried these:


still shows #value!

i try this:


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