ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Auto Filter (https://www.excelbanter.com/excel-worksheet-functions/159083-auto-filter.html)

Ant[_3_]

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



bj

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




Ant[_3_]

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







All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com