Ignore #N/A when ranking

[Celticshadow]

Hi All

I have the below figures in column N. I am using the below formula to rank the figures in column N but it is returning #N/A in each corresponding cell in column M,thus how do I get the formula to ignore the error #N/A and rank the other figures.


=SUMPRODUCT((N4> N$4:N$15)/COUNTIF(N$4:N$15,N$4:N$15))+1

18.50
0.83
14.50
68.00
57.00
46.00
66.00
92.00
39.00
#N/A
14.00
#N/A


Thanks in advance.

Kind Regards

 

[Juggler_IN]

Is there a VBA UDF for this?