F
FARAZ QURESHI
I have two columns A and B.
Some of the cells in A are blank.
Rest contain entries x, y and z.
Is there way of "FILTERATION" whereby I can have the Column A's cells
showing x, y and <blank> cells?
EXCEPT for maintaining an extra column with the logical formula
=if(or(a1="x",a1="y",isblank(a1)),"Y","N")
Some of the cells in A are blank.
Rest contain entries x, y and z.
Is there way of "FILTERATION" whereby I can have the Column A's cells
showing x, y and <blank> cells?
EXCEPT for maintaining an extra column with the logical formula
=if(or(a1="x",a1="y",isblank(a1)),"Y","N")