As long as the range *doesn't contain* the logical value TRUE...

=LOOKUP(1E100,1/(A1:J1),A1:J1)

--
Biff
Microsoft Excel MVP


"Mark" wrote in message
...
Is there a way to return the rightmost non-zero number? My spreadsheet
requires zeroes rather than blanks so this function doesn't work. Thanks!

"T. Valko" wrote:

To return the *last* (rightmost) numeric value in a range:

=LOOKUP(1E100,B2:W2)

--
Biff
Microsoft Excel MVP


"Jennifer" wrote in message
...
Hi Everyone,

See subject above. In column A, I have a long list of properties.
Columns
B through W are dates, and the data listed below shows various
percentages.
Not all of the cells are populated, as I leave them blank until I
receive
the
data.

In column V, I am trying to pull the most recent data (i.e. the
rightmost
cell related that is NOT blank). I have tried everything: SUMIF, RANK,
ISNUMBER. ISNUMBER worked, but I would have to update the formula each
week,
which is a pain.

Is there a faster way to do this? This is kind of hard to explain in
writing, so please let me know if you'd like to see my spreadsheet.