Hello,
I am looking for a solution that will count the number of hits greater than a value in consecutive columns. Also, looking for the formula to be interchangeable based on the desired number of consecutive occurrences. For example, count the number of times 3 (or more, adjustable) that back to back columns had a value greater than 50%.
Data sample:
Each number value is on the same row and specific to each column.
20% 50% 60% 30% 70% 100% 50% 10%
If I was targeting 3 consecutive columns greater than 50% I would like the formula to output 1 (based on a count of meeting this criteria). If the target was 2 consecutive months with 50% than the output would be 2.
Please let me know if this is possible without the use of VBA.