Auto filter problems

Closed
am - Oct 20, 2009 at 07:33 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 21, 2009 at 07:14 AM
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
Related:

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 21, 2009 at 07:14 AM
Hello

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