Auto filter problems [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

i am facing a problem with auto filter. excel 2003
i have 2000 rows and about 6 coloumn. i have saved my data.
due to some reason i cant find some items when sorted through coloum a.
say for eg : coloumn a consists company names. ( abc, xyz, aaa, bcc) coloumn b: contains : name of person.

when i find the name of company abc from drop down list of coloumn a i cant find its name anywhere.
when i make a find by ctrl f . i can find it .
when i make a find it in coloumn B: THRU drop down list and find for the respective name of person i can find it.

in coloumn i have problem for only few of the company names. resti can see it. i tried changin name, putting it with space withou space. but nothing helped.

when in need i wnt to find i am not able to thru auto filter

please help what can i do.

ankit

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello

Just one suggestion
Please ensure that there are no blank lines in the filtered area
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4223 users have said thank you to us this month