I have a table - 300 rows & 47 columns. The task is to filter the data based on 3 dependent drop down lists. Hopefully not using PQ or macros, is it possible to create a filter formula that dynamically selects the columns and column values?
=filter(D2:AX300),(D2:AX2="Column Name")*(D3:AX300="Input Name")
=filter(Table_1),(Table_1([@["Column Name")*(Table_1="Input Name")
Some various iterations of that to incorporate all possible 6 conditions. I'm a little out of my depth on this, so looking for some help.