# Multi-criteria filtering

#### Emily

##### Active Member
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

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
What is the expected result?

It should be

a CN1234
b CN1234
a DN1234
b DN1234
c DN1234

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

I get:

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

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

On 2002-09-28 03:59, Emily wrote:
I get:

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

"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...
ABCDE
1FieldAFieldBNew
2aCN1234TRUE
3bCN1234FieldAFieldB
4bCN4567aCN1234
5bCN4567bCN1234
6cCN4567cCN4567
9bDN1234
10cDN1234
11aCN1234
Sheet1

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

Replies
2
Views
177
Replies
6
Views
588
Replies
23
Views
407
Replies
6
Views
182
Replies
7
Views
270

1,218,575
Messages
6,143,313
Members
450,477
Latest member
teresab543

### 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.

### Which adblocker are you using?

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

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