Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto filter
Is it possiable to filter more than 1000 rows with autofilter? and if so, how?
|
#2
|
|||
|
|||
Select your range and apply the data|autofilter.
I bet you're seeing a maximum of 1000 unique entries under that dropdown. The range is still filtered--excel just shows a max of 1000 entries. Debra Dalgleish has some tips you may like: http://www.contextures.com/xlautofilter02.html#Limits (and you could always use a custom filter and type what you want (or contains what you want). Lisa Files wrote: Is it possiable to filter more than 1000 rows with autofilter? and if so, how? -- Dave Peterson |
#3
|
|||
|
|||
Yeah, I was afraid of that - thanks Dave!!
"Dave Peterson" wrote: Select your range and apply the data|autofilter. I bet you're seeing a maximum of 1000 unique entries under that dropdown. The range is still filtered--excel just shows a max of 1000 entries. Debra Dalgleish has some tips you may like: http://www.contextures.com/xlautofilter02.html#Limits (and you could always use a custom filter and type what you want (or contains what you want). Lisa Files wrote: Is it possiable to filter more than 1000 rows with autofilter? and if so, how? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter Limit Question | Excel Discussion (Misc queries) | |||
auto filter question | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |