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 |
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 |
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