Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
in data/filter/auto filter | Excel Worksheet Functions | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Auto-filter won't filter | Excel Worksheet Functions |