finding first column not equal to a value

[daveydave60]

is there a way to find the first cell not equal to a value. I know i can use the the match function to find the first cell equal to a certain value, but i want to find the first cell NOT EQUAL TO a value.

[daveydave60]

i know im new, but i really would apprecite the help.

[mangesh_yadav]

could you give an example, i.e. what is the output that you are looking for ones you find the non-matching cell, do you want the cell address, or the value

Mangesh

[daveydave60]

if the first cell is not, say 0, return 1. if the 45th cell isnt 0, return 45.

[mangesh_yadav]

This will work for only 1 non-zero number in the range. Does not work for more than 1 non-zero numbers.

=SUMPRODUCT(--(A1:A10<>0),ROW(A1:A10))
press control + shift + enter

Will try for more than 1 non-zero numbers till then

- Mangesh

[Domenic]

Try...

=MATCH(TRUE,A1:A100<>0,0)

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!