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

Thanks in advance,

Brett


--
self_made1Posted from - http://www.officehelp.in

Brett,

You could try this

in B1, enter 0
in B2, =IF(F2F1,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)

"self_made1" wrote in message
...

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

Thanks in advance,

Brett


--
self_made1Posted from - http://www.officehelp.in