Reading from Excel: Cells with formula are read as "somethin" instead of null values

[borna.molnar-erhatic]

Hello!

I know the title must be confusing but I have the following problem. I have an Excel table that contains cells with the IF formula that is supposed to do nothing ("") if the condition is met. See example:

So in my oppinon if the condition is met this cells shouldn’t even pop out in Dynamo. But they do! And they don’t pop out as Null values, but as “something” that is nothing. See picture:

How do I get rid of this Lists with no values? Is there a better way of doing it in Excel to avoid this problem overall?

[khuzaimah.ElecEng]

it is not empty, it have a value of “”, so make a logic node with == against “”, then use filter by bool mask node, it should work

[borna.molnar-erhatic]

Great tnx!