Hi!

What does: "does not work" mean?

Are you getting an error? An incorrect result?

Did you enter the formula as an array? After typing the formula, instead of
just hitting ENTER you MUST use the key combination of CTRL,SHIFT,ENTER.
When done properly Excel will place curly braces { } around the formula. You
must use the key combo to accomplish this. You can not just type them in.

Biff

"Tom" wrote in message
oups.com...


Unfortunately the suggested formula does not work


wrote:
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?