Forum Discussion
Pull Yearly CAD/USD Averages Into Simple Table
I'm looking to pull in the monthly average of CAD to USD exchange rates into a nice monthly table without having to update it. I can currently pull in the daily numbers, going back a year using TODAY...
Can you share an Excel file or some screenshots highlighting what you're trying to achieve?
LouisDeconinck Here is a screengrab of what I'm trying to achieve, a running average per month of the CAD to USD exchange rate. I would like the month in the title, as well as the number below to update regularly without us having to google the exchange rate for each month when we need it. We only ever need the last year's data, so as time passes it should update accordingly.
So in my perfect situation, the far right would be today's month and average rate, then working backwards to the left per month.
