Using AutoFilter

  • Thread starter Thread starter DollarBill
  • Start date Start date
D

DollarBill

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
 
Ron Coderre said:
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
Click to expand...

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


DollarBill said:
Ron Coderre said:
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
Click to expand...

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.
Click to expand...
 
Ron Coderre said:
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
Click to expand...

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.
Click to expand...

What's the difference between "ONLY have a T" and "standalone T"?




Ron Coderre said:
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
Click to expand...

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.
Click to expand...
 
Dave said:
What's the difference between "ONLY have a T" and "standalone T"?
Click to expand...

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??
 
I had to use:

Equals: *_t_*
(asterisk, space, t, space, asterisk)

containts: t
ignored my space characters.
 
Dave Peterson said:
What's the difference between "ONLY have a T" and "standalone T"?
Click to expand...

Ta, Tb, Tc OR T.
Ron Coderre said:
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
Click to expand...

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.
Click to expand...
Click to expand...
 
Dave Peterson said:
I had to use:

Equals: *_t_*
(asterisk, space, t, space, asterisk)

containts: t
ignored my space characters.
Click to expand...

Ah-Hah...that's it. Thanks for that. Now it makes sense. * is any
character.

Nice job and thanks.
 
Back
Top