Hello!

I have a table A1:D10 (all cells are results from IF function).

I need excel to generate table where all cells with value 'FALSE' are removed. It should look like table F1:I2.

I know that one option would be copy - paste values - find 'FALSE' - delete all shift cells up, however I need this process to happen automatically.

Any suggestions?

Screenshot_148.jpg