Search:

That's OK, no need to fret, even forums are subject to occasional quirks and flukes. Thanks for coming back to let me know.

THe formula you're looking for might be this, for example in O4, then copied down:

=IF(C4<>"n", "", N(O3)+1)


You can use that same formula on your new sheet, but for the first cell on that...