Rank Formula - When a Range Contains Zeroes

[ststern45]

I have a range of 10 values in cell range Y4 through Y13
1 Y4 = 0
2 Y5 = 2
3 Y6 = 1
4 Y7 = 2
5 Y8 = 0
6 Y9 = 1
7 Y10 = 1
8 Y11 = 0
9 Y12 = 1
10 Y13 = 3

How do I rank the above range from highest value to lowest value?

Thank you in advance


So in the above example starting in cell Z4 through Z13 it should be:
10,2,4,3,6,7,9,1,5,8

 

[ststern45]

The following formula is giving the incorrect ranking values from 1 through 10
=RANK($Y4,$Y$4:$Y$13)+COUNTIF($Y$4:$Y4,$Y4)-1

The above formula will work when there are no zeros in any of the cells.
Can the formula be changed if any cells from Y4 through Y13 contain a zero?

Thank you

 

[ststern45]

I found a solution. Formula in previous post worked.

 

[Peter_SSs]

I found a solution. Formula in previous post worked.

Glad to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.