L
Leonhardtk
I've found solutions for finding the last non-blank/non-zero value in a
column, but I couldn't figure out how to convert for a row:
Previously I had five cells to populate (H6-L6). What I need is the last
value that is completed. The first week would only have H6, the next week
I6, etc...
The formula I had (which worked fine):
=IF(Q6="",IF(O6="",IF(M6="",IF(K6="",IF(I6="",G6,I6),K6),M6),O6),Q6)
(A1:A9)
Now that I have 10 cells (H6-Q6) to fill out, I can't use the formula above
as there are too many IF Statements).
Unfortunately, the value each week could go up or down, so I can't do
min/max.
Appreciate any insight you all might have.
V/R
KSL.
column, but I couldn't figure out how to convert for a row:
Previously I had five cells to populate (H6-L6). What I need is the last
value that is completed. The first week would only have H6, the next week
I6, etc...
The formula I had (which worked fine):
=IF(Q6="",IF(O6="",IF(M6="",IF(K6="",IF(I6="",G6,I6),K6),M6),O6),Q6)
(A1:A9)
Now that I have 10 cells (H6-Q6) to fill out, I can't use the formula above
as there are too many IF Statements).
Unfortunately, the value each week could go up or down, so I can't do
min/max.
Appreciate any insight you all might have.
V/R
KSL.