Glasgowsmile
Active Member
- Joined
- Apr 14, 2018
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
Hello!
Running into an issue -- I think I can resolve it with Index, Match but I'm not entirely sure.
Let's say, I've got weekly data coming in Sun-Sat each week, all year long.
I want to find the Average of the Data on any given Weekday.
I want it to look at the DoW (let's say Sunday), go to the right worksheet and find all the of Sundays and then the data to the right for each date, then bring it back to the previous worksheet so I can average it out.
Photos below to help clarify. Please let me know if you need any further information.
https://imgur.com/a/u56ohbA
https://imgur.com/a/WHCXNmg
Running into an issue -- I think I can resolve it with Index, Match but I'm not entirely sure.
Let's say, I've got weekly data coming in Sun-Sat each week, all year long.
I want to find the Average of the Data on any given Weekday.
I want it to look at the DoW (let's say Sunday), go to the right worksheet and find all the of Sundays and then the data to the right for each date, then bring it back to the previous worksheet so I can average it out.
Photos below to help clarify. Please let me know if you need any further information.
https://imgur.com/a/u56ohbA