Home |
Search |
Today's Posts |
#1
|
|||
|
|||
AutoFilter only filtering first 1000
Hi All
I have recently found out that Autofilter only filters the first 1000 unique records. My database has 24,000 entries and I was wondering if anyone know if Auto filter can be changed to filter all entries? Thanks Denise |
#2
|
|||
|
|||
I think you're mistaken, Denise. It means first 1,000 UNIQUE entries. So, if
you put your 24,000 entries into groups, you would have more than 1,000 groups? THAT is the limitation as I read it. ******************* ~Anne Troy www.piersontech.com www.mrexcel.com "Denise Robinson" wrote in message ... Hi All I have recently found out that Autofilter only filters the first 1000 unique records. My database has 24,000 entries and I was wondering if anyone know if Auto filter can be changed to filter all entries? Thanks Denise |
#3
|
|||
|
|||
Try also Debra's page at:
http://www.contextures.com/xlautofilter02.html#Limits "Limits to Dropdown Lists" where she details some workarounds -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Denise Robinson" wrote in message ... Hi All I have recently found out that Autofilter only filters the first 1000 unique records. My database has 24,000 entries and I was wondering if anyone know if Auto filter can be changed to filter all entries? Thanks Denise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frozen panes in Excel should stay put when using autofilter. | Excel Discussion (Misc queries) | |||
Can I AutoFilter an entire workbook? | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
Function Help | Excel Worksheet Functions | |||
Amortization Schedule | Excel Worksheet Functions |