CODEWITHSUNDEEP
arraysfiltergoogle-sheets-formulaflattengoogle-query-language
Captain_D
Captain_D

Reputation: 63

Using ArrayFormula with Query or Filter

I have a set of data and I want to filter it on some conditions.

My data goes here(image1):

enter image description here

Similarly, I have another column that has a unique value of A column and it goes like this (image 2):

enter image description here

Now my problem is I am trying to filter my data(image 1) with the name matching in image 2 with one additional condition.

My filter formula works fine but only for the first name in image 2.

I am trying to get output for all the names mentioned in image2 using the Array formula. Here is my formula :

=ARRAYFORMULA(Filter(data!$A2:C,Data!$A2:A='Sheet1'!H2:H,Data!$B2:B="MATCH"))

Upvotes: 1

Views: 631

Answers (1)

player0
player0

Reputation: 1

try:

=INDEX(SPLIT(FLATTEN(QUERY(QUERY({A2:A, B2:B, C2:C}, 
 "select max(Col3)
  where Col2 = 'MATCH'
  group by Col3 
  pivot Col1"),,9^9)), " "))

enter image description here

Upvotes: 1

Related Questions