Forum Discussion

DeFacto's avatar
DeFacto
Copper Contributor
Jul 23, 2022
Solved

Count the columns which have cells with specific text and meet the comparison condition

Hello,   Lets say i have a table like that: I need to get a count of columns where line #1 contains "LB" and cell in line #2 is greater or equal to cell in line #3. In this particular case th...
Formulas and Functions
  • Sekoleyte's avatar
    Sekoleyte
    Jul 23, 2022

    DeFacto 

    After i filter the range according to the comparison condition, i counted how many cells we have. Then i divided it by rows number.

     

Sekoleyte's avatar
Sekoleyte
Iron Contributor
Jul 23, 2022

DeFacto 

After i filter the range according to the comparison condition, i counted how many cells we have. Then i divided it by rows number.

 

Resources