# Thread: Find value NOT equal to 0 (Excel 2002/SP2)

1. ## Find value NOT equal to 0 (Excel 2002/SP2)

I want to determine in which cell in an array (consisting of 1 row) the first cell from the left is NOT equal to 0 (zero).
I have found several formulas to find a value 'equal to' but not the opposite of this.

Anyone any ideas?

2. ## Re: Find value NOT equal to 0 (Excel 2002/SP2)

If your data is on row 2:

=ADDRESS(ROW(A2:I2),MIN(IF((A2:I2<>"")*(A2:I2=0),C OLUMN(A2:I2),999)))

(array formula, confirm with control-shift enter!!!)

3. ## Re: Find value NOT equal to 0 (Excel 2002/SP2)

=INDEX(A1:G1,MATCH(1,INDEX(ISNUMBER(A1:G1)*(A1:G1< >0),1,0),0))

gives the first non-zero number from A1:G1.

=CELL("address",INDEX(A1:G1,MATCH(1,INDEX(ISNUMBER (A1:G1)*(A1:G1<>0),1,0),0)))

gives the address of the first non-zero number from A1:G1.

Aladin

4. ## Re: Find value NOT equal to 0 (Excel 2002/SP2)

Thank you for your quick reply! Works perfect.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•