How to Rank a set of data with #n/a, #VALUE!, in data

[Juggler_IN]

I need to rank a set of data in a UDF. For example, if the data set is:

[TABLE="width: 64"]
<colgroup><col></colgroup><tbody>[TR]
[TD]70[/TD]
[/TR]
[TR]
[TD]#VALUE ![/TD]
[/TR]
[TR]
[TD]54[/TD]
[/TR]
[TR]
[TD]41[/TD]
[/TR]
[TR]
[TD]95[/TD]
[/TR]
</tbody>[/TABLE]

then the command Application.Rank results is an error. Is there a way to ignore #VALUE ! or #N/A and still rank the rest of data? I need a VBA solution.