Reputation: 13
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:
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