Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto filter problem | Excel Worksheet Functions | |||
auto filter doesn't return cells containing the custom search wor. | Excel Worksheet Functions | |||
Cell reference in the auto filter custom list | Excel Discussion (Misc queries) | |||
Custom Auto Filter default setting should be contains | Excel Worksheet Functions | |||
Custom Filter Problem | Excel Discussion (Misc queries) |