View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rae Rae is offline
external usenet poster
 
Posts: 27
Default 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!