FILTERING SINGLE CHAR
 

Am using XP, Excel 2002. Have no problem when using Excel 1997. The problem
is filtering single characters like a,b,c A,B,C. I am getting either only a
or only b or only c when you hit the arrow key. If you choose any character,
say a the filtered rows will give you a and A. Do I need to set up anything
in Options just to distinguished upper from lower case? This never happens
to me in Excel 1997.
thanks, (second request, no respond from MS yet from my first request)

FILTERING SINGLE CHAR
 

You could add another column to your table, and use it to check for the
exact entry. For example, assuming characters are in column D --

In cell K1, type the character you want to filter for.
In cell E1, type the heading, "Check"
In cell E2, enter the formula: =EXACT(D2,$K$1)
Copy the formula down to the last row of data
Filter the Check column for TRUE

will A wrote:
Am using XP, Excel 2002. Have no problem when using Excel 1997. The problem
is filtering single characters like a,b,c A,B,C. I am getting either only a
or only b or only c when you hit the arrow key. If you choose any character,
say a the filtered rows will give you a and A. Do I need to set up anything
in Options just to distinguished upper from lower case? This never happens
to me in Excel 1997.
thanks, (second request, no respond from MS yet from my first request)


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

FILTERING SINGLE CHAR
 

I dont think you're getting my point. I can correct this problem with less
steps than you suggested, however, my point is, the filtering is working in
XL97 but not in XL2000 nor 2002. I appreciate your helping me and hope that
some MS guys could look into this bug.

"Debra Dalgleish" wrote:

You could add another column to your table, and use it to check for the
exact entry. For example, assuming characters are in column D --

In cell K1, type the character you want to filter for.
In cell E1, type the heading, "Check"
In cell E2, enter the formula: =EXACT(D2,$K$1)
Copy the formula down to the last row of data
Filter the Check column for TRUE

will A wrote:
Am using XP, Excel 2002. Have no problem when using Excel 1997. The problem
is filtering single characters like a,b,c A,B,C. I am getting either only a
or only b or only c when you hit the arrow key. If you choose any character,
say a the filtered rows will give you a and A. Do I need to set up anything
in Options just to distinguished upper from lower case? This never happens
to me in Excel 1997.
thanks, (second request, no respond from MS yet from my first request)


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html