I am trying to use the auto filter function on a sheet that has about 47000
rows in it. The column I want to auto filter has about 14900 different
values in it. So many of the values are repeated. The problem is that when
I open the auto filter, all of the different values are not available. Only
the first 1000 of them. Is this normal? Is it a limitation of the auto
filter function? I can use custom and pull the info that I need, so that is
working.

Just curious...


Steven K.
--
Steven Keeling
Pal Services
DSCR Richmond VA