Forum Discussion

Frost's avatar
Frost
Frequent Visitor
9 years ago
Solved

New table filter including zero

I have a table of 15 rows with two columns (A+B), where A has values from zero to five (3 rows zero and 7 rows with values=10 rows) but also some blank values (5 rows). I want to create a new table w...
Need Help
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    Frost

     

    use

     

    if(isblank(column), "value if blank", "value if not blank")

Frost's avatar
Frost
Frequent Visitor
9 years ago

Thanks, but is there a way to do this without creating a extra column in the original table? I have a number of these to filter out...

Frost's avatar
Frost
Frequent Visitor
9 years ago

....and yes there is:

 

Table = Filter(Sheet1, if(ISBLANK(Sheet1[A]), FALSE(), TRUE()))

 

Thanks for your help!