View Single Post
  #2   Report Post  
Alan
 
Posts: n/a
Default

I'm assuming youre using AutoFilter. This will only display 1000 different
entries in the drop down list, although it will filter the whole column of
what can be seen.
Advanced Filter is an option,
Look here on Debra Dalgleish's site, she is the expert on this subject,
http://www.contextures.com/xladvfilter01.html
Regards,
Alan.
"Kompu Kid" wrote in message
oups.com...
Hello All:

I am finding out that Excel 2000 is not doing a good job with filters
when it comes to cells with large amounts of text.

I just wanted to see if this is others' experience as well, not me
doing something wrong.

Comments appreciated.

Deguza