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

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

Try does not contain
~*~*

The asterisk is a wildcard character (as is the question mark).

When you really want that asterisk (or question mark), you use the tilde (~* or
~?).

And if you really want the tilde, you'd use two of them (~~).



JMay wrote:

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

--

Dave Peterson