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)


"yowee" wrote in message
...
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?