CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulatransposearray-formulasgoogle-sheets-query
Adam Lough
Adam Lough

Reputation: 23

Search a range and bring back a stacked column of results

I know this is possible using a combination of probably =FILTER, ARRAYFORMULA and probably QUERY but hopefully, the examples will explain it better than words can.

Testing Data

Effectively, I have an output (the top table) and I want the formula that will bring back the dates each person has a mismatch (bottom table)

I hope that's clear enough.

Upvotes: 2

Views: 26

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(QUERY({A2:A10, TRIM(SPLIT(TRANSPOSE(QUERY(TRANSPOSE(
 IF(B2:G10="mismatch", B1:G1, )),,999^99)), " "))}, "where Col2 is not null", ))

0

Upvotes: 1

Related Questions