Filter not finding all cells in columns

Y

yowee

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?
 
P

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
 
Top