how manage row number of next not empty cell in relation current cell? not want use vba!
| | b | 1 x 3 (expected result) 2 3 4 x 7 (expected result) 5 6 7 8 x
if formular located in cell b3, how row number of next not empty cell in col starting a3?
try formula in b1
, copy down:
=if(a1="","",match(true,index((a2:a$100<>0),0),0)+row(a1)-1)
change a$100
need
Comments
Post a Comment