I have a row of numbers. I would like to get the number of consecutive times the number is above 2500. For example, A1 through Z1 contain numbers. If C1 through E1 contain numbers above 2500 I want the number returned to be 3. Now, if there are several times that this happens between A1 and Z1, then i want the 'longest streak'.
Please tell me you all understand!?!?!
Please tell me you all understand!?!?!