Wildcard in index sort filter formula

[creative999]

Hi

Wildcards dont seem to work in a index sort filter formula. Any suggestions here:

=IFERROR(INDEX(SORT(FILTER(DATA!$A$2:$AC$1000,(DATA!$B$2:$B$1000>=$A$1)*(DATA!$C$2:$C$1000="PUBLISH*"),""),4,-1),1,3),"--")

 

[hagia_sofia]

Hello, would this work for you (depending on wheter e.g. EPUBLISH is allowed or not):

=IFERROR(INDEX(SORT(FILTER(DATA!$A$2:$AC$1000,(DATA!$B$2:$B$1000>=$A$1)*(ISNUMBER(FIND("PUBLISH",DATA!$C$2:$C$1000))=TRUE),""),4,-1),1,3),"--")

 

[hagia_sofia]

The following should address the problem of the first one:

=IFERROR(INDEX(SORT(FILTER(DATA!$A$2:$AC$1000,(DATA!$B$2:$B$1000>=$A$1)*(MAP(DATA!$C$2:$C$1000,DATA!$C$2:$C$1000,LAMBDA(x,y,COUNTIFS(x:y,"PUBLISH*")))>0),""),4,-1),1,3),"--")

 

[felixstraube]

if you want the values to start with publish you could also use:

LEFT(DATA!$C$2:$C$1000, LEN("Publish"))="Publish"