barszczula
barszczula

Reputation: 13

Filter Xmatch with Wildcard does not work

I am stuck overflow! I want to filter an array (its a single line as the example) using XMATCH to return columns based on wildcard criteria. While I am able to create the formula without XMATCH wildcards, the wildcard example stucks my flow!

Here's the array:

Array

Xmatch with wildcard (exchanged order of parameters compared to later more complex examples), which works properly:

=XMATCH({"*FYE*FYE*","*Budget'*"},INDEX(B1:O1,1,),2,-1) 

Now, I want to adjust the formula to be compatible with Filter to return only columns that match criteria:

=LET(myArr,B1:O1,output,FILTER(myArr,(ISNUMBER(XMATCH(INDEX(myArr,1,),{"*FYE*FYE*","*Budget'*"},2,-1)))),output)
=LET(myArr,B1:O1,output,FILTER(myArr,(ISNUMBER(XMATCH(INDEX(myArr,1,),{"*FYE*FYE*","*Budget'*"},2,-1)))),output)

Who would be able to help me unstuck my flow?

Upvotes: 0

Views: 22

Answers (0)

Related Questions