Query function, select columns based on criteria from a cell-CodePudding

Home > Net > Query function, select columns based on criteria from a cell

Query function, select columns based on criteria from a cell

Time：01-31

I would like to use Query function and pull the columnn base on cell criteria. So something like: =QUERY(Data!A3:U,"select A,B" select the columns with a header same as cell A1,1)

I've try to select with arrayformula but did'nt figure anything out.

CodePudding user response：

Use FILTER:

=Filter(A4:U,{1,1,C3:U3=A1})

CodePudding user response：

try:

=FILTER(Data!A3:U; Data!A3:U3=A1)

Page link：https//www.codepudding.com/net/688183.html

Prev:How to use a Lambda function with Reduce to repeat row N numbre f time in google sheets

Next:How do I remove spaces between words when the words are in the same cell?

Tags：

excelgoogle-sheets

Links：
CodePudding