Advanced Filter - Help

A

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
 
D

Debra Dalgleish

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top