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