Filter function, returning wanted columns

[ajocius1]

I have table with data in Excel sheet. I want to return list of records meeting criteria in a different sheet, but selecting only columns that I want to see. I have used formula:
=FILTER(FILTER(Table1[[A]:[D]];Table1[A]="ES");{1;0;1;0}). 4 Colums in source sheet, labeled A->D.
Where A to D corresponds to column letter. My table has 4 columns and I want to return only column 1 and 3 of this list.

Formula above led to error.

Have tried this with same formula, but using ;{1;0;1;0****} for rows and it did work, but I need column filtering.

 

[Fluff]

Try it like

=FILTER(FILTER(Table1[[A]:[D]];Table1[A]="ES");{1\0\1\0})

 

[ajocius1]

thank you so much! "\" instead of ";" worked like a charm!

 

[Fluff]

You're welcome & thanks for the feedback.