Forum Discussion
janitor_8
Nov 08, 2021Copper Contributor
Welcome To Excel Space!!
You Can Discuss Any Type Of Discussion. Here, Everyone Can Do Any Type Of Excel(or any microsoft app related) Discussions Here. Enjoy!!😊
chrisjms
Oct 11, 2023Copper Contributor
Hi,
Thanks, that works well.
It does mean I then had to do a further formula to look at the pivot table data and pull based on the month and the bar.
Is there a way to do it all in one formula?
HansVogelaar
Oct 11, 2023MVP
And alternative:
- chrisjmsOct 16, 2023Copper ContributorThanks so much, I sent days trying to work out how to do it, now I see it, it makes sense.
So thanks also for the education.