Formula based on the lastest date for date
Pete,
this is what it looks like, I want the % of portfolio colum to to take work
out automatically the percentage as i add in new columns over time with
updated values...
(the only formula i have in there is '% of portfolio' ie fund value/total
portfolio value)
Value Value Value % of
Fund 07/05/08 06/06/08 04/07/08 Portfolio
Fund 1 £29,337.63 £28,887.07 £26,653.90 33.94%
Fund 2 £14,769.50 £14,615.92 £13,677.61 17.42%
Fund 3 £13,674.17 £13,595.00 £12,147.22 15.47%
Fund 4 £9,947.85 £9,920.07 £9,876.94 12.58%
Fund 5 £20,190.88 £19,242.85 £16,169.34 20.59%
Totals £87,920.03 £86,260.91 £78,525.01
thanks
andy
"Pete_UK" wrote:
Perhaps you could explain what you have and what you are trying to do
in a bit more detail. Post any formulae that you have, whether they
work or not.
Pete
On Sep 1, 12:03 pm, Andy B <Andy
wrote:
I'm trying to base a simple '% of the total' formula on the latest range of
data at the latest date. Every time i insert a new column to update the data
i have to manually change the formula as i don't know how to write a formula
that will pick up the latest date and base the formula on that column.
can anyone help with this?
thanks
andy
|