| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria in same Column | Excel Worksheet Functions | |||
| Another multiple criteria/column question | New Users to Excel | |||
| Countif multiple criteria within the same column | Excel Discussion (Misc queries) | |||
| Sumproduct - multiple criteria in Column A | Excel Worksheet Functions | |||
| multiple criteria in one column | Excel Worksheet Functions | |||
Hybrid Mode
