Hello. I have searched everywhere and tried everything I know but cant seem to get this.
I have daily data over many years. I would like to average the all of one weekday in the same month. For example, All Mondays in November over the course of many years.
It is laid out like this:
...A............B.............C...................... BR..............BS
1 DATE.......11/02/09...11/03/09.............02/14/16.....02/15/16
2 VALUE......2.97.........3.45...................4.9.............1.9
So using the date row I would like to average the Value row for specific days in specific months.
Thanks so much!!!!!!!!!!!!
EDIT: I APOLOGIZE FOR MY LAZINESS TO NOT CORRECT SPELLING IN THE THREAD TITLE. I WOULD EDIT OR DELETE AND RE-POST IF I COULD
Bookmarks