Hello Forum,

Thank you in advance for your help.

I'm looking for some help writing this formula or VBA script. I have a report consisting 10,000 records and for each line, I'm trying to calculate a consistent value count from left to right when the score is greater than a set number. IE: 94 in this example.

I'm looking for a formula or script to count based on a number greater than 94 starting from cell A1, then to A2, and so on and stopping when the value is less than the 94.

See below

Example #1 Expected result = 3
A1=96
B1=98
C1=100
D1=79
E1=99
F1=97

Example #2 Expected result = 2
A1=96
B1=98
C1=27
D1=99
E1=99
F1=97


Thanks again for your help