I have a query that needs to be run for every row in a list. It works nicely when written for a single row:
QUERY(MaraRankData,
"select J,I,H,G,F,E where
A='"&E3&"' and
B='"&B3&"' and
C="&C3&" and
D="&D3&"",
0
)
That outputs a row of data, as desired. But when I wrap it in ARRAYFORMULA, it still only outputs one row instead of many:
=ARRAYFORMULA(
QUERY(MaraRankData,
"select J,I,H,G,F,E where
A='"&E3:E&"' and
B='"&B3:B&"' and
C="&C3:C&" and
D="&D3:D&"",
0)
)
Google Sheets isn't throwing any errors, so I don't know what I'm doing wrong. How can I get ARRAYFORMULA to work with my QUERY so I don't have to repeat the formula on every row?
filter
, please post an answer: I'd be interested in such a solution.=FILTER({E:E,F:F,G:G,H:H,I:I,J:J},A3:A=E3:E)
The first part is just to re-order the columns in the curly brackets. The second is because A to E seems like the only column that mattered as B looks at itself, C looks at itself, etc. Really though a data set would be nice, and perhaps more explanation on the problem. Maybe I just don't understand.