Hello,
i have 3000 cells in Excel with different positive/negative values. I need to make a statistic what is the largest number of CONSECUTIVE negative cells. Please help me, i don't know which function to use.
Thank you
P.S. i'm using Excel 2003