Finding the First Non Zero number in a list

[sdohertyccb]

Is there a way to pick the first non zero number in a list? The data is in a dynamic range that is updated each time a program is run, and I need to find the first non zero number in the list. Also, the data cannot be sorted to use the MATCH function as the numbers are specific to a date that is used for several sets of data. For example:

Date	       Set1	Set2	Set3
3/31/2006	0	0	0
4/30/2006	0	250	0
5/31/2006	350	200	120
6/30/2006	200	300	90

Is there a formula that will give me the first non zero number for Set1?
Any help you can give me would be greatly appreciated.
Thanks in advance for looking at this for me.

 

[Gerald Higgins]

Is it possible that a zero could appear AFTER a non zero number ?

For example, is it possible that Set1 could contain values like this ?

0
0
350
200
0
400

?

 

[RoryA]

For example:

=INDEX($B$2:$B$10,MATCH(TRUE,$B$2:$B$10<>0,0))

array-entered with Ctrl+Shift+Enter.

 

[sdohertyccb]

Awesome solution. Thanks so much for your help...

 

[RoryA]

Glad to help.