 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Using AutoFilter
I have asked a similar question here awhile ago. I'm want to AutoFilter a column that contains multiple string data. If I use AutoFilter to look for just the bit of the string that is say "A", Excel returns every row that contains ANY string in the column that contains an A. The data in the column is something like: A, AB, AC, AD, B, BD, 2B, etc. I want to filter for just A or AB but Excel returns everything that has an A in the string. I tried quotes but that didn't work. Any solutions? Thanks. -Bill Please confirm that you are performing the below steps....and getting incorrect results. Select the column range of cells From the Excel main menu: <data><filter><autofilter> Click the dropdown list and choose: Custom Then engage these settings: Equals A OR Equals AB Click the [OK] button Does that help? *********** Regards, Ron XL2002, WinXP > I have asked a similar question here awhile ago. > [quoted text clipped - 8 lines] > > -Bill > Please confirm that you are performing the below steps....and getting > incorrect results. [quoted text clipped - 19 lines] > > XL2002, WinXP No. Here's what I want to do. I want to filter for T. There is data in the column that equals T, Ta, Tb, Tc, At, Bt, etc. I want to filter for JUST T. Select the column range of cells From the Excel main menu: <data><filter><autofilter> Click the dropdown list Now you have 2 options.... 1) Select T from the list.......Done. or 2)Choose: Custom Then engage these settings: Equals T Click the [OK] button......Done *********** Regards, Ron XL2002, WinXP > > Please confirm that you are performing the below steps....and getting > > incorrect results. [quoted text clipped - 23 lines] > the column that equals T, Ta, Tb, Tc, At, Bt, etc. I want to filter for > JUST T. > Select the column range of cells > [quoted text clipped - 14 lines] > > Click the [OK] button......Done If I do this, it will filter rows that ONLY have T. That is not the case. The data contains other letters too. I need a way to filter for a standalone T. Thanks. > If I do this, it will filter rows that ONLY have T. That is not the case. > The data contains other letters too. I need a way to filter for a > standalone T. What's the difference between "ONLY have a T" and "standalone T"? > > Select the column range of cells > > [quoted text clipped - 20 lines] > > Thanks.  SignatureDave Peterson >> If I do this, it will filter rows that ONLY have T. That is not the case. >> The data contains other letters too. I need a way to filter for a >> standalone T. > > What's the difference between "ONLY have a T" and "standalone T"? I think "ONLY a T means no other letters in the cell, like cell="T" "standalone T" might look like cell="T ABC" Beege maybe begins with T_ (T space character) or contains _T_ (space T space) But who knows for sure?? > >> If I do this, it will filter rows that ONLY have T. That is not the case. > >> The data contains other letters too. I need a way to filter for a [quoted text clipped - 6 lines] > > Beege SignatureDave Peterson I had to use: Equals: *_t_* (asterisk, space, t, space, asterisk) containts: t ignored my space characters. > maybe > [quoted text clipped - 18 lines] > > Dave Peterson SignatureDave Peterson >I had to use: > [quoted text clipped - 3 lines] > containts: t > ignored my space characters. Ah-Hah...that's it. Thanks for that. Now it makes sense. * is any character. Nice job and thanks. >> If I do this, it will filter rows that ONLY have T. That is not the >> case. >> The data contains other letters too. I need a way to filter for a >> standalone T. > > What's the difference between "ONLY have a T" and "standalone T"? Ta, Tb, Tc OR T. >> > Select the column range of cells >> > [quoted text clipped - 21 lines] >> >> Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.