#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Auto Filter

Can I enter something into the custom section of an auto fitter so that it
looks for lines that just have one character e.g. an initial as apposed to a
name?



Thanks


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Auto Filter

your best bet is to use a helper column with LEN() and dot eht auto filter on
this column.

"Ant" wrote:

Can I enter something into the custom section of an auto fitter so that it
looks for lines that just have one character e.g. an initial as apposed to a
name?



Thanks



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Auto Filter

Sorted, Thanks

"bj" wrote in message
...
your best bet is to use a helper column with LEN() and dot eht auto filter
on
this column.

"Ant" wrote:

Can I enter something into the custom section of an auto fitter so that
it
looks for lines that just have one character e.g. an initial as apposed
to a
name?



Thanks





Reply
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 Count for Auto Filter Doesn't Function under certain circumst Jonathan Horvath Excel Discussion (Misc queries) 2 August 17th 07 03:51 AM
Auto Number the Rows of Auto Filter Result ashish128 Excel Discussion (Misc queries) 3 April 29th 07 06:41 PM
in data/filter/auto filter sp8 Excel Worksheet Functions 2 May 12th 06 01:03 AM
Excel auto filter doesn't recoginize case - won't filter AA from A Mikey Excel Discussion (Misc queries) 1 September 29th 05 08:18 PM
Auto-filter won't filter Jane Excel Worksheet Functions 7 February 9th 05 08:20 PM


All times are GMT +1. The time now is 06:35 PM.

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

About Us

"It's about Microsoft Excel"