|
Formula if/then and looking forwad - Please HELP
I have several years of daily data and I'm trying to determine if a daily
goal was met based on several criteria. 1. If column b =15 "goal met" 2. if column b is <15 has a zero or looks blank then look forward 6 cells and the first two cells that have data are both = 15 "goal met" if not "not met" 3. If column b is blank and after looking forward 6 cells and the resuls are still blank the results should be "absent" |
Formula if/then and looking forwad - Please HELP
One shot at this
Try in C2: =IF(B2=15,"goal met",IF(SUMPRODUCT(--(OFFSET(B3,,,6)=15))=2,"goal met","absent")) Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Lisa" wrote: I have several years of daily data and I'm trying to determine if a daily goal was met based on several criteria. 1. If column b =15 "goal met" 2. if column b is <15 has a zero or looks blank then look forward 6 cells and the first two cells that have data are both = 15 "goal met" if not "not met" 3. If column b is blank and after looking forward 6 cells and the resuls are still blank the results should be "absent" |
| All times are GMT +1. The time now is 04:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com