Count consecutive increases

Hi,

Can anyone help me write a formula that counts consecutive increases in a row of numbers?

In a row of numbers, I would like to start at the rightmost one, move leftwards, check if next number is smaller than the previous. If it is, increase count by one, if not abort and write count in an adjacent cell.

I am not looking for the VBA solution...

Please see enclosed file for clarification(?).

Thanks!

Hi,

I seem to recall a Mr. Excel podcast that covered a similar scenario not so long ago - it was to do with counting winning and losing streaks. Take a look here: http://www.mrexcel.com/podcast/learnexcelpodcast.html and search for 'win streak'. Might be of use.

HTH,

SamuelT

Try this formula in G2 copied down

=COLUMNS(B5:F5)-LOOKUP(2^15,CHOOSE({1,2},0,MATCH(2,1/(B5:F5<=A5:E5))))

This is an array formula that needs to be confirmed with CTRL+SHIFT+ENTER so that curly braces appear around the formula in the formula bar

Sweet daddylonglegs, thanks lots!!

Hi all,

I have the same problem but just need to know how to modify the formula to go from left to right.

Thanks in advance.