Rank in descending order only if positive

[L.LEE]

Hi

Could you pls help me with the formula to rank by descending order only if column A has a positive number. Otherwise, formula returns a blank.

Pls see attached file.

thanks

[Phuocam]

Try:

=IF(A2>0,RANK(A2,$A$2:$A$4),"")