Forum Discussion

GmPasman's avatar
GmPasman
Copper Contributor
Aug 16, 2022
Solved

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's avatar
    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)

     

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
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)

 

 

  • GmPasman's avatar
    GmPasman
    Copper Contributor
    Aug 16, 2022

    Harun24HR 

     

    Thanks!  Works as I wanted. 

     

    Case closed now.

Resources