Hi all,
I have a sample spreadsheet of exactly what I am facing, but an excerpt.
Column A aims to find the compounded annual return of historical total assets, which is from coumn C onwards.
However, some data goes back to 1991, and some to 1993 and so on.
I'm trying to come up with a command that finds the compounded growth rate and simply drag it down to apply to all cells, taking into account of the different years.
Please advise.
Sincere thanks in advance.
Last edited by jonnyyyl; 02-06-2012 at 04:19 PM.
please help..i'm feeling bleak and i've been stuck on this for over a week. thanks.
Working on it.
Paul
I found this on the same forum. Good stuff. If it is still not clear, let me know
http://www.excelforum.com/excel-gene...reference.html
Paul
maybe
=(C2/OFFSET(C2,0,(COUNT(C2:X2)- COUNTIF(C2:X2,0))-1)^1/B2)-1
drag down..
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks