Hi there, I was wondering if someone could help me with a formula.
I have a table similar as below and looking for a formula to get an average of each exchange rate of every month.
Thanks in advance.
Date Currencies XXX to USD
2-Jan-17 JPY 116.32
2-Jan-17 SGD 1.45
2-Jan-17 AUD 1.39
3-Jan-17 JPY 117.07
3-Jan-17 SGD 1.45
3-Jan-17 AUD 1.39
2-Feb-17 JPY 116.32
2-Feb-17 SGD 1.45
2-Feb-17 AUD 1.39
3-Feb-17 JPY 117.07
3-Feb-17 SGD 1.45
3-Feb-17 AUD 1.39
Bookmarks