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"