Match Worksheet Function

[MacroMike]

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

[Domenic]

Try the following...

=MATCH(TRUE,I33:DL33>0,0)

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

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

[MacroMike]

Thanks for the help Domenic but when I try this all I get in the box is

#VALUE!

Your code does make logical sense but Im having trouble implementing it.

What do you mean when you say validate it with control shift and enter.

Thanks again

Mike

[Domenic]

Instead of pressing just the ENTER key when confirming the formula, press CONTROL+SHIFT, then while holding them down hit the ENTER key. Excel will then place braces {} around the formula and you'll know you've entered it correctly.

Hope this helps!

Thanks for the help Domenic but when I try this all I get in the box is

#VALUE!

Your code does make logical sense but Im having trouble implementing it.

What do you mean when you say validate it with control shift and enter.

Thanks again

Mike

[MacroMike]

Thanks Domenic - Works a treat