Counting consecutive periods

S

self_made1

I have a spreadsheet listing monthly % returns in a column and woul
like to count the number of consecutive up and down months for a give
time period (ie there were 5 months in a row that were up during th
last year). Is there a function or way to do this without macros?

Thanks in advance,

Bret
 
B

Bob Phillips

Brett,

You could try this

in B1, enter 0
in B2, =IF(F2>F1,H1+1,0)
and copy down. You can see the max value in the column

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top