i have month end dates in column A ...
i have stock perf in columb B
the length of data can keep on changing depending on what stock i have...
what i want to compute is for every year in the data set
the yearly cumulative return....which uses the formula..
=product( 1+ range ( of that dat which belongs to a particular year ) - 1 }..so an array formula....
how can i do this .....
i have stock perf in columb B
the length of data can keep on changing depending on what stock i have...
what i want to compute is for every year in the data set
the yearly cumulative return....which uses the formula..
=product( 1+ range ( of that dat which belongs to a particular year ) - 1 }..so an array formula....
how can i do this .....