LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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..


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto filter problem Martin B Excel Worksheet Functions 2 November 25th 06 10:00 PM
auto filter doesn't return cells containing the custom search wor. annelidae Excel Worksheet Functions 2 August 24th 06 02:07 AM
Cell reference in the auto filter custom list Andre Croteau Excel Discussion (Misc queries) 1 February 14th 06 02:03 PM
Custom Auto Filter default setting should be contains dmc Excel Worksheet Functions 0 June 14th 05 07:54 AM
Custom Filter Problem plindman Excel Discussion (Misc queries) 2 June 2nd 05 04:30 PM


All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"