=LOOKUP(9.99999999999999E+307,A2:K2)

would return the last numeric value from A2:K2.

Duser wrote:
I need to run a search in excel that runs in the same row across columns from
Right to Left and understands to skip empty cells and stop as soon as it gets
to a cell with any number in it. I would put this formula in a totals column
on the far right so i dont have to manual update data. Thank You