FILTERATION ON MULTIPLE CRITERIA OF A COLUMN
 

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

FILTERATION ON MULTIPLE CRITERIA OF A COLUMN
 

Try:

Data==Autofilter=Custom--"does not equal" -- z

"FARAZ QURESHI" wrote:

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

FILTERATION ON MULTIPLE CRITERIA OF A COLUMN
 

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?


"Toppers" wrote:

Try:

Data==Autofilter=Custom--"does not equal" -- z

"FARAZ QURESHI" wrote:

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