i need to count max consecutive increases in a row. Ex:
12,16,20,22,9,10,11 answer: 3 (12-16, 16-20, 20-22)
9,10,11,6,7,13 answer: 2 (9-10, 10-11 or 6-7,7-13)
I want to do this without macro or vba. Is there any possibility to use a formula?
Thank you,
Bookmarks