=LOOKUP(10000000000,6:6) if it's a number

"Leonhardtk" wrote:

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,I 6),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.