I am trying to make a formula that automatically correctly numbers rows, but skips certain blank rows. I am often copying and inserting rows, and want the formula to be correct then as well. I am thinking some combination of countif and offset may work. I essentially want the number to count all the rows above itself to a fixed cell ( in this case, $A$5) and add one, without counting rows=0. Copying and pasting =OFFSET(A6,-1,0)+1 works, where A5=1, but resets to one after a blank row. =COUNTIF($A$5:A6,">0")+1 works for the blank/zero values but does not update correctly when I insert a copied row, and A5=1 and A6=2. Any ideas?
Bookmarks