how i do to make a self filter in more than 3000 lines?

V

V. Ivanov

When i´ll use a self filter, i can´t use this function in more than 1.000
lines, what i need to do?
 
R

Ron Coderre

Actually, the Auto Filter works with that many records, BUT the dropdown
lists will only display up to 1,000 unique items. There are workarounds you
can use to facililitate what you may want to do. For instance, by filtering
on one of the fields, other fields may list more values. For more options,
see Debra Dalgleish's site:

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

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top