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!
|