Excel 2007

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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

The reason for a new table is the new table will calculate a compounded rate of return for the time period entered.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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