I think you want consecutive numbers skipping blank rows
Then in E1 enter 1
in E2 enter (assuming Col B is the col you are testing for non-blank values)

=(IF(ISBLANK(B2),"",MAX($A$1:A1)+1))

and copy down

"Brent E" wrote:

Good day everybody,

I am looking for a formula to search the column above for next nonblank cell
doing up.

Explanation:
I have a list of integers in column E. They are broken out between sections
of blank rows for readability. I am trying to figure out a formula that will
allow additional cells to be added to each section, and have the next section
dynamically adjust reference to the last non blank cell in preceding section
above.

For example:
For ease of reference:
data in section 1 of Col E. (we'll call this section "Programs"):
1
2
3

Section 2 in ColE (we'll call this "Products"):
4
5

I would like to enter a formula to perform:
If above cell is blank, search column going up for the next nonblank cell.
Then once the nonblank cell is identified, the value in the cell below will
equal the value above + 1.

Pseudo code would be something like:
If E9 location-1 (e.g. cell above) = not blank, then E9=E8 +1,
Else search range upwards for next nonblank cell
Value of current cell below= value of next upwards non blank cell + 1

Note: All the cells in the column are currently set to adjust their values
based on the preceding cell:
current cell = preceding cell + 1, except if blank.

Example of Application:
This formula would provide so that If I insert a row in the "Programs"
section and enter a 4 under existing data 3, than the 4 in the people section
will automatically test for the next nonblank cell above and adjust to 5, and
in turn will cause the current 5 to adjust up also.

Thanks for your assistance
Cordially,