Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
vlookup must return a value that is greater than | Excel Worksheet Functions | |||
Return value if cell greater then 0 | Excel Worksheet Functions | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions |