In Excel How to list all columns in a row that have a certain value?

I probably use the wrong search terms, but cannot find a solution for a (very simply) action I want to do in Excel. I have a table with rows that consist of over 1000 cells (columns). Per column...

excel

Formulas and Functions

Harun24HR
Aug 16, 2022
GmPasman Use FILTER() function.

=FILTER(B1:G1,B4:G4=FALSE)

Or below formula without having check row.
=FILTER(B1:G1,B2:G2+B3:G3>=8)