Pivot, Sumproduct or both?
 

Howdy,

I have a large data set that I am trying to summarize (20k row x 13 col).
The data contain are for equipment (~1200 unique) and a value roughly on a
quarterly basis. I am interested in determining when the value is greater
than 2 for 2 or more successive quarters.

I have tried several different approaches such as creating a dummy column in
the data if the value is 2, and using a Pivot to sum up, by quarter.
Visually, it is easy to see the successive quarters, but I would like to
reduce the list to just those items that meet the criteria.

Any suggestions?

Regards,
Tim