FILTER FUNCTION...ABLE TO PICK SPECIFIC COLUMNS

[daveyc18]

=FILTER(AAA!A2:X1000000,(AAA!W2:W1000000=B3)*(AAA!S2:S1000000=28))

the source has up to column X

is there a way to show only specific columns and not return the entire data set?

eg return only columns A,B, W, and S?

 

[Coyotex3]

I believe so, you can wrap your formula around the Choosecol formula. Maybe:

=CHOOSECOLS(FILTER(AAA!A2:X1000000,(AAA!W2:W1000000=B3)*(AAA!S2:S1000000=28)),1,2,23,19)

 

[Fluff]

How about

=choosecols(FILTER(AAA!A2:X1000000,(AAA!W2:W1000000=B3)*(AAA!S2:S1000000=28)),1,2,23,19)

 

[daveyc18]

tks guys

 

[Fluff]

Glad we could help & thanks for the feedback.