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.
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
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.
Alternatively =IF(A1=0,0,COUNTIF($A$1:A1,">0")) dragged down
Great!
Thanks to both!
Bookmarks