I have a table with advance filters... in one of the column I have different
values as follows

ABC
ABCDE
ABCDEF

Since all start with with ABC, If I put ABC it will filter positive all
I only need those that fully meet "ABC", how can I deal with this?

datafiltercustomequal to abc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alberto Ast" wrote in message
...
I have a table with advance filters... in one of the column I have
different
values as follows

ABC
ABCDE
ABCDEF

Since all start with with ABC, If I put ABC it will filter positive all
I only need those that fully meet "ABC", how can I deal with this?

AutoFilterCustom From Custom Filter window select 'equal to' and enter 'ABC'

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

I have a table with advance filters... in one of the column I have different
values as follows

ABC
ABCDE
ABCDEF

Since all start with with ABC, If I put ABC it will filter positive all
I only need those that fully meet "ABC", how can I deal with this?

Thanks you both but I am using advance filter... I just type into the cell
ABC but it select all cells starting with ABC

"Jacob Skaria" wrote:

AutoFilterCustom From Custom Filter window select 'equal to' and enter 'ABC'

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

I have a table with advance filters... in one of the column I have different
values as follows

ABC
ABCDE
ABCDEF

Since all start with with ABC, If I put ABC it will filter positive all
I only need those that fully meet "ABC", how can I deal with this?

Excel 2007
Advanced Filter
Alberto: You are quite right, typing =ABC won't do.
Here is the right way:
http://www.mediafire.com/file/madyk3...10_09_09a.xlsx

Enter this as text (preform the cell as text or start with an apostrophe):

'=ABC
(to retrieve all the Ed's, but not the Eddie's.)

Or use a formula that evaluates to that same text string.
="="&"ABC"
or
="=ABC"



Alberto Ast wrote:

I have a table with advance filters... in one of the column I have different
values as follows

ABC
ABCDE
ABCDEF

Since all start with with ABC, If I put ABC it will filter positive all
I only need those that fully meet "ABC", how can I deal with this?

--

Dave Peterson

I saved this from a previous post, but forgot to change this line:
(to retrieve all the Ed's, but not the Eddie's.)
to
(to retrieve all the ABC's, but not the ABCDEF's.)

Dave Peterson wrote:

Enter this as text (preform the cell as text or start with an apostrophe):

'=ABC
(to retrieve all the Ed's, but not the Eddie's.)

Or use a formula that evaluates to that same text string.
="="&"ABC"
or
="=ABC"

Alberto Ast wrote:

I have a table with advance filters... in one of the column I have different
values as follows

ABC
ABCDE
ABCDEF

Since all start with with ABC, If I put ABC it will filter positive all
I only need those that fully meet "ABC", how can I deal with this?

--

Dave Peterson

--

Dave Peterson