BYROW-ARRAYTOTEXT- FILTER Functions- An Excel Challenge
I came across an Excel Challenge on LinkedIn, and I loved the versatility of solutions provided. So, I simulated it to show you my solution and share the benefit with you.
Here is The link to the original post by Excel BI:
https://www.linkedin.com/posts/eforex...
In this tutorial I show you how I solved the problem using BYROW, FILTER, ARRAYTOTEXT and Other Dynamic Array functions. It’s more simple than you imagine.
I encourage you to check the post and see how other experts solved the same challenge using:
Classic Functions, Poer Query, DAX…etc.
If you like my solution to the challenge, give it a thumbs up and subscribe to support my channel, and to be notified when new tutorials are released…The Best is Yet to Come.
Music Attribution
Beach Party - Islandesque by Kevin MacLeod is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/...
Source: http://incompetech.com/music/royalty-...
Artist: http://incompetech.com/