FILTERATION ON MULTIPLE CRITERIA OF A COLUMN

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")
 
F

FARAZ QURESHI

Thanx toppers
But that was just an example.
There are around 40 different branch names in the column to be filtered.
Senior Manager should see the cases whose branches are not available in
addition to the two or more branches he like.
Any Idea?
 
Top