Filter not finding all cells in columns

[Guest]

I have been asked to find out why the auto filter is not finding all the
cells in columns.
eg; When you look down in the cells you find a number, but when you select
autofilter then look for the number it may or not be picked up in the filter
(all)
Any ideas please?

 

[Peo Sjoblom]

See:

http://www.contextures.com/xlautofilter02.html#Limits


it is just the dropdown list that has the limit, you can still use custom
filter and type in any number(s)

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Paul B]

yowee, auto filter has a limit, have a look here for more information on it
and a workaround

http://www.contextures.com/xlautofilter02.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003