Apologies if this isn't explained particularly well.
I have a table containing dates in column A and a number in column B. What I would like to do is average the numbers in column B based on the day and month in column A and for it to show the latest full date range.
So in the example below, the response would be 01/01/2020 and 12.5
I have a table containing dates in column A and a number in column B. What I would like to do is average the numbers in column B based on the day and month in column A and for it to show the latest full date range.
So in the example below, the response would be 01/01/2020 and 12.5
01/01/2017 | 10 |
01/01/2018 | 15 |
01/01/2019 | 15 |
01/01/2020 | 10 |