Greetings,
Given an array of a fund value over time, I would like to come up with an array formula (and if my memory serves me correctly - it is definately possible using ROW() and OFFSET() combinations - maybe with SUBTOTAL and SUMPRODUCT) for calculating the maximum draw down of the fund.
Any ideas? Thanks people,
Alex
Given an array of a fund value over time, I would like to come up with an array formula (and if my memory serves me correctly - it is definately possible using ROW() and OFFSET() combinations - maybe with SUBTOTAL and SUMPRODUCT) for calculating the maximum draw down of the fund.
Any ideas? Thanks people,
Alex