I have a dataset that I need to filter and display for graphing purposes. The first row is FY, so say 2004 through 2023. But, the last year can change; the columns are fixed, but the last year can be 2023, or 2022, and the unused columns show a 0. I filter this data this way, and it works. What I need to do now is filter for the rows below that contain the formula "=IF*". There is a mix of SUM and IF, I only want the IF rows.

This returns a nice array of FALSE and TRUE for exactly the right columns for each row:

=ISNUMBER(SEARCH("=IF*",FORMULATEXT($D$185:INDEX($237:237,COUNTIF($161:$161,">0")+COLUMN($C$161)))))

But both these formulas return #VALUE!:

=FILTER(FILTER($B$184:$AV$237,$B184:$AV$184<>0),ISNUMBER(SEARCH("=IF*",FORMULATEXT($D$185:INDEX($237:237,COUNTIF($161:$161,">0")+COLUMN($C$161))))))

=FILTER($B$161:INDEX($174:174,COUNTIF($161:$161,">0")+COLUMN($C$161)),ISNUMBER(SEARCH("=IF*",FORMULATEXT($D$185:INDEX($237:237,COUNTIF($161:$161,">0")+COLUMN($C$161))))))

I thought the ISNUMBER would be what to "include" in the FILTER.

Thanks in advance for any help!