I've officially wasted the morning trying to solve this problem. I'm being asked to identify the longest streak of negative returns. I am given one column of returns and one cell to program in the answer. The remainder of the workbook is protected. I've attached an example.
Example: Returns File.xlsx
So far I'm trying formulas based on =MAX(FREQUENCY(B:B,<0),B:B) CSE
The only thing that is clear to me is that I am clueless.
HELP!
Bookmarks