Thanks Debra,
I think I know what's happening now. I am getting
matches for all 4 columns correctly. But the advanced filter gives me the
results in alphabetical order. For example, if one of my criteria cells is
"WEEKLY.LOW.INTENSITY" and the next cell in the same column is
"WEEKLY.HIGH.INTENSITY", I get the correct rows OK, but in alphabetical
order. So in the filtered view, WEEKLY.HIGH.INTENSITY comes first. I was
hoping that the filtered view would maintain the same order as the criteria.
Is there any way to do this? I could work around it by sorting everything
aphabetically before doing my compare, but this really complicates things.


"Debra Dalgleish" wrote:

It should work with period characters. What text is in the criteria
string, and what unexpected results are being returned?

simpsons_rule wrote:
Thanks for the info folks. But The strings I am matching on are less than 255
characters long (no more than about 30 characters). The only other thing I
can think of, maybe the advanced filter criteria can't handle some characters
(the strings I am trying to match on will have period chars, e.g
123.ABC.XYZ). Any ideas?

"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..



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