Multi-criteria filtering

Emily

Active Member
Joined
Aug 28, 2002
Messages
304
Is it possible to use function to solve the following data fulfill both criteria :
1. Retain All without duplicate when column A is "a"
2. When Column A is "a", the value in column B is used as criteria to retain data even column A is not "a". Also no duplicate.

Column A Column B
a CN1234
b CN1234
b CN4567
b CN4567
c CN4567
a DN1234
a DN1234
b DN1234
c DN1234
a CN1234

I hope you can catch my meaning
Thanks in advance
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
On 2002-09-27 23:21, Emily wrote:
It should be

a CN1234
b CN1234
a DN1234
b DN1234
c DN1234

I get:

{"a","CN1234";
"b","CN1234";
"c","CN4567";
"a","DN1234";
"c","DN1234"}

Please compare these 2 subsets.
 
Upvote 0
I get:

{"a","CN1234";
"b","CN1234";
"c","CN4567";
"a","DN1234";
"c","DN1234"}

Please compare these 2 subsets.

"c, CN4567" should not be there.
Anyway, how do you got this subset?
 
Upvote 0
On 2002-09-28 03:59, Emily wrote:
I get:

{"a","CN1234";
"b","CN1234";
"c","CN4567";
"a","DN1234";
"c","DN1234"}

Please compare these 2 subsets.

"c, CN4567" should not be there.
Anyway, how do you got this subset?

There is another difference between your subset and mine. No comment on that?

Here is what I tried...
aaMultiCritAdvFilter Emily.xls
ABCDE
1FieldAFieldBNew
2aCN1234TRUE
3bCN1234FieldAFieldB
4bCN4567aCN1234
5bCN4567bCN1234
6cCN4567cCN4567
7aDN1234aDN1234
8aDN1234cDN1234
9bDN1234
10cDN1234
11aCN1234
Sheet1

This message was edited by Aladin Akyurek on 2002-10-04 03:25
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,915
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top