My first thought would be that it has something to do with the fact the * is
a wildcard...try using a different character maybe?


"JMay" wrote in message
...
In my table with autofilter applied I have (Col L)
that has the following formula in it (rows 5 to 1600)

=IF(ISNUMBER(FIND("Acc",H5)),"Accrual","")

In most cases (90%) the cell produces a zero string
In others I have overwritten the formula with either

**ELIM
or
**OFFSET

I am trying to Filter the report on Col L using
Custom and selecting the "Does not contain"
and in the box entering **

But I'm getting WEIRD results,,
Can someone suggest a better solution?

Tks in Advance..