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