Debra Dalgleish has a work around for autofilter at:
http://www.contextures.com/xlautofilter02.html#String

Maybe it'll give you an idea.

(I'm having trouble connecting to her site right now.)

simpsons_rule wrote:

Hi,
I have an advanced filter set up to match on the contents of 4 columns,
using the criteria =("=" & text) . It works fine, except on one column the
text is quite long, and the match only seems to work on part of the text. So
I get matches where the the first part of the text matches, but the end of
the text is different. How can I set up the criteria to get an exact match on
the text regardless of length? Thanks..
--
In the nation of the blind, the one eyed man is king..

--

Dave Peterson