Apr 27 2020 06:16 PM
Apr 27 2020 10:57 PM
There's no simple way to do this
MVP Mynda Treacy has a cool hack using a Pivot Table Filter box here
https://www.youtube.com/watch?v=NqvB-DqIuP4
and MVP Leila Gharani has one here if you have the new FILTER function in Office 365
Hope that helps
Wyn
MVP
Australia UTC+ 8
If this answer was the best response please click the button
I also happily accept likes