Excel party

[Sir Tokyo Sexwale]

I want the first non-zero number in a row.

 

The row is say....

 

0, 0, 0, 79, 65, 78, 100, 130, 96, 95

 

The formula I'm using isn't quite right - 

 

INDEX(A1:J1,MATCH(TRUE,INDEX(A1:J10),0),0))

 

It's just giving me the last value - being 95. What I'm looking for is a formula giving me 79

[Nathan Explosion]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here