return first value greater than zero
 

This is probably easy, but I just can't figure it out...

Here is an example of what I'm trying to accomplish:
(Data Sheet)
A B C D E F G
1 Date 8/25 8/26 8/27 8/28 8/29 8/30
2 Fcst 0 0 0 0 250 500

(Summary Sheet)
A B
1 SUMMARY
2 Qty of First Req 250 (this is what i'm having trouble with... i need it
to pull the first non-zero value from Data Sheet, Row 2, Columns A thru G)

3 Date of First Req 8/29 (Ideally, i would like it to also pull the
corresponding Date of first non-zero value)

Thanks for the help!

return first value greater than zero
 

To get the value

=INDEX(A2:G2,MATCH(TRUE,A2:G20,0))


to get the date

=INDEX(A1:G1,MATCH(TRUE,A2:G20,0))


both formulas need to be entered with ctrl + shift & enter

the second needs to be formatted as date or else you will get a serial
number
counting the number of days since Jan 0 1900

--


Regards,


Peo Sjoblom

"Rae" wrote in message
...
This is probably easy, but I just can't figure it out...

Here is an example of what I'm trying to accomplish:
(Data Sheet)
A B C D E F G
1 Date 8/25 8/26 8/27 8/28 8/29 8/30
2 Fcst 0 0 0 0 250 500

(Summary Sheet)
A B
1 SUMMARY
2 Qty of First Req 250 (this is what i'm having trouble with... i need
it
to pull the first non-zero value from Data Sheet, Row 2, Columns A thru G)

3 Date of First Req 8/29 (Ideally, i would like it to also pull the
corresponding Date of first non-zero value)

Thanks for the help!

return first value greater than zero
 

Try this:

=INDEX(A1:G1,MATCH(1,INDEX((A2:G20)*(ISNUMBER(A2: G2)),),))

Just press ENTER



"Rae" wrote:

This is probably easy, but I just can't figure it out...

Here is an example of what I'm trying to accomplish:
(Data Sheet)
A B C D E F G
1 Date 8/25 8/26 8/27 8/28 8/29 8/30
2 Fcst 0 0 0 0 250 500

(Summary Sheet)
A B
1 SUMMARY
2 Qty of First Req 250 (this is what i'm having trouble with... i need it
to pull the first non-zero value from Data Sheet, Row 2, Columns A thru G)

3 Date of First Req 8/29 (Ideally, i would like it to also pull the
corresponding Date of first non-zero value)

Thanks for the help!

return first value greater than zero
 

I'm doin' a butt-wigglin' happy dance at my desk :)

It worked perfectly!

Thanks!

"Peo Sjoblom" wrote:

To get the value

=INDEX(A2:G2,MATCH(TRUE,A2:G20,0))


to get the date

=INDEX(A1:G1,MATCH(TRUE,A2:G20,0))


both formulas need to be entered with ctrl + shift & enter

the second needs to be formatted as date or else you will get a serial
number
counting the number of days since Jan 0 1900

--


Regards,


Peo Sjoblom

"Rae" wrote in message
...
This is probably easy, but I just can't figure it out...

Here is an example of what I'm trying to accomplish:
(Data Sheet)
A B C D E F G
1 Date 8/25 8/26 8/27 8/28 8/29 8/30
2 Fcst 0 0 0 0 250 500

(Summary Sheet)
A B
1 SUMMARY
2 Qty of First Req 250 (this is what i'm having trouble with... i need
it
to pull the first non-zero value from Data Sheet, Row 2, Columns A thru G)

3 Date of First Req 8/29 (Ideally, i would like it to also pull the
corresponding Date of first non-zero value)

Thanks for the help!