Advanced Filter (2000)

**pccoyle** · 2003-02-27 19:19

Boy, is my brain foozled today. I have a list of product descriptions, included in some is the word suite. I have tried the following as filters, but I'm not getting the correct result.
The filters I used were ="*suite*", when that did not produce the correct information I then tried =*suite* <img src=/S/brainwash.gif border=0 alt=brainwash width=15 height=15> <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

**JohnBF** · 2003-02-27 19:51

In the filter drop down, select Custom. Within the dialog box (it's way down there in the options) select "contains", enter only "suite" as your criteria.

**pccoyle** · 2003-02-27 19:56

Thanks John, that certainly works. Being in Advanced Filter didn't think <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15> <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> of the simple Filter solution.
I am still curious as to why the Criteria in Advanced Filter did not give me the same answer.

**Andrew Cronnolly** · 2003-02-27 20:25

If you enter *suite* in the Advanced Filter criteria range it should work. No need for quotation marks or the = sign.

Andrew C

**pccoyle** · 2003-02-27 20:36

Thanks Andrew, tried that but still no joy. Attached is a small subset of the data

**Andrew Cronnolly** · 2003-02-27 20:48

Paul,

I think your problem arises from having blank rows in your criteria range. If you set the Criteria range to A13

14 it should work.

Andrew

**pccoyle** · 2003-02-27 21:23

AAAARGH! <img src=/S/bwaaah.gif border=0 alt=bwaaah width=123 height=15> What a dumbo i am.
Thanks Andrew <img src=/S/groan.gif border=0 alt=groan width=16 height=15>

Thread: Advanced Filter (2000)

Thread Tools