Can anyone please help me out - probably an easy one for most of you out there.

Im trying to return the position of the first non zero value in a range using the match worksheet function.

Initially I was using the code to return the position of the first "1" in a range when i was only dealing with 0s or 1s.

Now I am dealing with any integer above 0 so im basically looking to return the position of the first non zero value.

So far I have tried

=MATCH(NOT(0),I33:DL33,0)

but it doesnt seem to work.

Thanks in advance


Mike