Dynamically Filtering Non-adjacent Columns
This is a 3 steps process:
1. Get the column numbers using the XMATCH function
2. Choose those columns using the CHOOSECOL function
3. Filnally filtering them
=FILTER(
CHOOSECOLS(tblSales,XMATCH(J2:L2,tblSales[#Headers])),tblSales[Customer]=I3)
#excel #exceltips #programming
![ЛЕГИОНКА ДЕЛО ГОВОРИТ [DOTA2]](https://images.videosashka.com/watch/DHkwP_b-NiI)
