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"

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"