Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter: Inverse
Hi,
I want to filter a list of data whereby it is the exception, ie, text<aaa AND text<bbb AND text<ccc. I tried the following but could not. Please help. ************************** text text text <aaa <bbb <ccc ************************** and I also tried this: ************************** text <aaa <bbb <ccc ************************** Is this wrong? Thanks, Val |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter: Inverse
Assuming text is running in col A, in A2 down
Put in say, E2: =IF(A2="","",IF(ISNUMBER(MATCH(A2,{"aaaa","bbb","c cc"},0)),"",1)) Copy E2 down, then autofilter col E for 1's to get the exceptions -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dolphin" wrote: Hi, I want to filter a list of data whereby it is the exception, ie, text<aaa AND text<bbb AND text<ccc. I tried the following but could not. Please help. ************************** text text text <aaa <bbb <ccc ************************** and I also tried this: ************************** text <aaa <bbb <ccc ************************** Is this wrong? Thanks, Val |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter: Inverse
Did you also try:
text text text <aaa <bbb <ccc Max wrote: Assuming text is running in col A, in A2 down Put in say, E2: =IF(A2="","",IF(ISNUMBER(MATCH(A2,{"aaaa","bbb","c cc"},0)),"",1)) Copy E2 down, then autofilter col E for 1's to get the exceptions -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dolphin" wrote: Hi, I want to filter a list of data whereby it is the exception, ie, text<aaa AND text<bbb AND text<ccc. I tried the following but could not. Please help. ************************** text text text <aaa <bbb <ccc ************************** and I also tried this: ************************** text <aaa <bbb <ccc ************************** Is this wrong? Thanks, Val |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter: Inverse
Dear Max,
You have solved my many problem in this forum. Now I have problem. I have three work sheets Named "paintings", "Silver", and "Textiles". These are Invetory record. It have Column like- ID No. Name of Item Pur_Cost Every sheet's ID No. Start from 001 I submit daily report to my boss that particular item sold and its purchase cost was this and sale value is this and gross profit/loss is this. My Daily Sales report's format is - A B C ID No. Name of Item Cost_price Sale_price 001 Paintings =Formula() 001 Textiles 001 Silver 002 Textiles 003 Silver 003 Paintings I want to use a formula in Column C that could determine cost value from related worksheet after matching ID No. and Name of sheet Hope u only can help me. Regards RRS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter Using Calculaions | Excel Worksheet Functions | |||
Advanced Filter not working | Excel Worksheet Functions | |||
Hiding advanced filter | Excel Discussion (Misc queries) | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
advanced filter | Excel Worksheet Functions |