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.