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