If values in a column <> 0 then rank them in ascending order

[Gbricco]

Hello all,

I need a function that checks whether values in a range are different from 0 and if so, numbers them. This needs to happen for every n+1 value in the range. So the rank in column B changes depending on the values of column A.

Example:
A B

0	0
1	1
7	2
0	0
3	3

Any ideas?

Thanks

[Hercules1946]

Hello
Try this in B2 and copy down:

=IFERROR(IF(A2=0,0, LARGE($B$1:$B1,1)+1),1) This assumes that your data starts on Row 2. If it starts on row 1, do exactly the same, but then copy the formula up to B1 as well.

[Pecoflyer]

Alternatively =IF(A1=0,0,COUNTIF($A$1:A1,">0")) dragged down

[Gbricco]

Great!

Thanks to both!