Last "non-blank" value in a Row...


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.
 
Ad

Advertisements

T

T. Valko

This will return the rightmost numeric value from the range if there is one:

=LOOKUP(1E100,H6:Q6)

If there isn't a numeric value in the range the formula will return #N/A. To
prevent the error you can use this version:

=IF(COUNT(H6:Q6),LOOKUP(1E100,H6:Q6),"")
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top