Jul 12, 2011 at 01:40 PM
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Jul 13, 2011 at 07:42 PM
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.
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022766 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