Advanced Filter - Help
 

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

Advanced Filter - Help
 

In the criteria area, use the same heading as is in the code column.
In the cell below, type: ="=009/04025"

Ant Nutting wrote:
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??

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html