Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

=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.