M
Mycotopian
how can I replace the #N/A with 0 or even a blank cell in my results
from the following statement =RANK(H4,$H$15:$H$30,)
from the following statement =RANK(H4,$H$15:$H$30,)
how can I replace the #N/A with 0 or even a blank cell in my results
from the following statement =RANK(H4,$H$15:$H$30,)
...units------Rank
#VALUE!
#VALUE!
43 4
29 5
54 2
46 3
#VALUE!
120 1
#VALUE!
#VALUE!
I attached a jpeg of the formula in action
Attachment filename: excel.jpg
Since I don't open attached files, EVEN JPEGs, you want to try to
state the problem in plain text?
Do you browse the web?
It wasn't really an attached file; it was just a link to a website.
Anytime you go to a web page you are running the same risk.
I sent it to (e-mail address removed)
...this is what I get with that formula. Instead of the cells being blank
they are assigned a value of 1.
Units_________Rank
Blank_________1
Thanks Harlan. I still got errors when there were ties but Its good
enough for now.