Programming problem

Job ID: 34611788

Budget: $25 – $50 USD

looking through a data set for 3 1's that occur in 3 consecutive columns then returns a 1. If 3 0's occur in a row than it loses the eligibility. I know how to look up if 3 ones or three zeroes occur in a row, however I dont know how to check to make sure that the 3 zeroes did NOT occur AFTER the 3 ones.
Related categories: Data Processing Excel Excel Macros