Hi!

Here's one way.

Entered with the key combo of CTRL,SHIFT,ENTER:

=INDEX(A1:L1,MAX(IF(A1:L10,COLUMN(A1:L1))))

Biff

wrote in message
oups.com...
How do I create a formula that returns the furthest to the right last
non zero number in a row with up to 15 columns

ie colums shown with values in cells A1 to L1


A B C D E F G H I J K L
1 4 6 0 8 4 0 7 5

How Do I create a formula to return the value of 5, in this case cell
I1?