Rank formula with 2 columns ignoring zero values

[gaftalik]

Hi everyone,

In column A1: A25 i have some cells with values and others are blank or equal to 0
In column C1:C20 i have the same thing
How to use a Rank formula in cells B1:B25 and D1:D20 to rank in ascending order using as criteria the data from column A1:A25 and C1:C20?

Thank you for your support !

 

[gaftalik]

No, the first one worked great thank you very much for your time and support !