Previous Topic Next Topic

Excel 2007

Closed
ExcelBeginner - Jul 12, 2011 at 01:40 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 13, 2011 at 07:42 PM
Hello,
I have a table that lists historical rates of returns for years between 1901 to 2010. I'd like to create a table that 1) will list each year between an input date range and 2) that shows the annual return for each year in that date range. For example, if the begin year and end year are input (e.g. 1920 begin year and 1950 end year), I want each year listed in that date range in one column and then the corresponding percent return in another column.

What formulas do I need to use to create this new table? I think I would use the VLOOKUP to produce the percent return but not sure what formula to use to list the years between a range.

Thank you for your help.
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 13, 2011 at 12:56 AM
If you filter your original table for the date range, you will get the desired result. So whywould u need a new sheet/table?
If you still want to do it, then you can filter the result and copy the appropriate columns to new sheet. if you record macro, you would get a macro template
0
ExcelBeginner
Jul 13, 2011 at 11:42 AM
The reason for a new table is the new table will calculate a compounded rate of return for the time period entered.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 13, 2011 at 07:42 PM
The should not copy and paste after filtration work ? If not, could you go into detail of your problem else it is just a guessing game for any one who try to help you
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses