View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default Auto-Filter-Custom Problem

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