In the attached is a user defined function: Capture3.JPGThe RightmostCount value is the maximum number of values (not years) you want to use in the calculation. If there are fewer than this number of values it will use as many as it can find in Myrange.
I've used it in column V of Sheet1.
I've also put what I think are not-quite-as-misleading figures (they a show a figure without stating which years are used) in column X.
The UDF is garbage. If someone uses this value as an average annual growth figure to help sell an investment product, it's a lie, for at least 2 reasons.
I've also put what I think are not-quite-as-misleading figures in column X (they don't show which years are used).
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote