I have a series of data that includes months going across the columns and in the rows are accounts. The cells are populated with the amount of sales for each account during each month. I am trying to find a formula to quickly note which accounts have more than six month of inactivity or "0" sales. However, the catch is that I need the search to begin with the first month that each account begins its sales. For example, one account can have its data beginning in March and another account can have its sales start in June. I need the search of consecutive 0 value cells to start from each account's first month of sales. The formula should return a value, such as "0" for accounts that do not have 6 consecutive months of 0 sales at any point since their first month of sales or "1" for accounts that do have 6 consecutive months of 0 sales at any point since their first month of sales. I've included a sample attachment. Thanks!
Bookmarks