Hi,
I added my filter command down heer.
When I try to add a column not in order, it masses all the data in the columns it shows.
What I mean is that I tried for example to add at the end, column B.
Any idea how to solve the problem?
=LET(
All_col,COLUMN(A:W),
data1,INDIRECT("'test'!o2"&parms!C1)=parms!B4,
data2,INDIRECT("'test'!q2:q"&parms!C1)=parms!C4,
FILTER(FILTER(INDIRECT("'test'!A2:w"&parms!C1),(data1)*(dat2)),(All_col=COLUMN(A:A))+(All_col=COLUMN(O:O))+(All_col=COLUMN(P:P))+(All_col=COLUMN(Q:Q))+(All_col=COLUMN(R:R))+(All_col=COLUMN(S:S))+(All_col=COLUMN(T:T))))
I added my filter command down heer.
When I try to add a column not in order, it masses all the data in the columns it shows.
What I mean is that I tried for example to add at the end, column B.
Any idea how to solve the problem?
=LET(
All_col,COLUMN(A:W),
data1,INDIRECT("'test'!o2"&parms!C1)=parms!B4,
data2,INDIRECT("'test'!q2:q"&parms!C1)=parms!C4,
FILTER(FILTER(INDIRECT("'test'!A2:w"&parms!C1),(data1)*(dat2)),(All_col=COLUMN(A:A))+(All_col=COLUMN(O:O))+(All_col=COLUMN(P:P))+(All_col=COLUMN(Q:Q))+(All_col=COLUMN(R:R))+(All_col=COLUMN(S:S))+(All_col=COLUMN(T:T))))