Can't hide N/A and get RANK to work

[kidb]

Hi all

I'm working on a horse tournament excel sheet for a riding club. Sometimes there are 5 competitors, other times 20. I'm almost finished but can't reach the finish line. The problem is to disable/hide the #N/A error because i can't get RANK formula to work if there is #N/A in it.

Column I has RANK formula =RANK(H4;$H$4:$H$30;1)
Column H has vlookup formula and if there is an #N/A somewhere from H4:H30 the RANK formula doesn't work.



Thanks
Kristján