Rankif Question

Hi guys,

I tried to rank a number of values and it worked with sumproduct. The problem is that some rows contain no value (or errors), so I wanted to rank only those with values.

A B Rank
1 Pepe 1 1
2 Pepe 2 2
3 Pepe N/A None

Please help.

Thanks!