Advanced Filter help

[Ant Nutting]

Hi All

I'm trying to filter a list using advanced filter. The problem i'm having is
that i'm picking up records i do not want, even if i use the unique record
check box. let me give you an example!
My record i want to pick up is code: 009/04025, however it seems to give me
all codes starting with 009/04025 eg 009/04025C, 009/04025CG, 009/04025SD
etc. The only item i want filtered is 009/04025. Is there maybe a wildcard
or something i should be using??
Thx
Anthony

 

[Aladin Akyurek]

Set up a criteria range, say X1:X2, where

X1 houses the label heading the codes and
X2 the formula:

="=009/04025"