So, basically I have an excel doc in which I want to assign an "item number" to each new section. Some sections only have 10 lines before the next item number but some have 50+. Is there a way to write a formula which references the next cell about it that contains a value (even if that cell is 20 rows above the current) and add 1 to it?? This is the theoretical solution I have devised, but if anyone else has a way of solving the problem I would love to hear it.
Thanks!
Bookmarks