| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
RESTRICTIONS
hi there ............... i want to know whther there is any restrictions in
excel for filteration ...?? because i have an data of around 12000 lines and if i filter it, it is applying filter upto row no. 5136 .......... 5137 and onwards rows are not filtered (even though i have selected all the 12000 rows while appling filter......... why ?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RESTRICTIONS
in xl2003 and below, you'll only see 1000 unique entries in the list under the
dropdown arrow. But if you're really not filtering all the rows, I'd remove the filter and select all the range and then reapply the filter. I'm guessing that even though you say you're selecting all the rows, I don't think you are. YESHWANT JOSHI wrote: hi there ............... i want to know whther there is any restrictions in excel for filteration ...?? because i have an data of around 12000 lines and if i filter it, it is applying filter upto row no. 5136 .......... 5137 and onwards rows are not filtered (even though i have selected all the 12000 rows while appling filter......... why ?? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RESTRICTIONS
Autofilter's drop-down will only show up to 1000 values in the list. You can
use Advanced filter as an alternative... "YESHWANT JOSHI" wrote: hi there ............... i want to know whther there is any restrictions in excel for filteration ...?? because i have an data of around 12000 lines and if i filter it, it is applying filter upto row no. 5136 .......... 5137 and onwards rows are not filtered (even though i have selected all the 12000 rows while appling filter......... why ?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RESTRICTIONS
HOW DOES ADVANCED FILTER WORKS ???
"Sean Timmons" wrote: Autofilter's drop-down will only show up to 1000 values in the list. You can use Advanced filter as an alternative... "YESHWANT JOSHI" wrote: hi there ............... i want to know whther there is any restrictions in excel for filteration ...?? because i have an data of around 12000 lines and if i filter it, it is applying filter upto row no. 5136 .......... 5137 and onwards rows are not filtered (even though i have selected all the 12000 rows while appling filter......... why ?? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RESTRICTIONS
Please go to Help Microsoft Escel Help and type advanced filter for more
details. this will give you much more information than would be typed here. "YESHWANT JOSHI" wrote: HOW DOES ADVANCED FILTER WORKS ??? "Sean Timmons" wrote: Autofilter's drop-down will only show up to 1000 values in the list. You can use Advanced filter as an alternative... "YESHWANT JOSHI" wrote: hi there ............... i want to know whther there is any restrictions in excel for filteration ...?? because i have an data of around 12000 lines and if i filter it, it is applying filter upto row no. 5136 .......... 5137 and onwards rows are not filtered (even though i have selected all the 12000 rows while appling filter......... why ?? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RESTRICTIONS
Another place to start:
http://contextures.com/xladvfilter01.html (From Debra Dalgleish's site) YESHWANT JOSHI wrote: HOW DOES ADVANCED FILTER WORKS ??? "Sean Timmons" wrote: Autofilter's drop-down will only show up to 1000 values in the list. You can use Advanced filter as an alternative... "YESHWANT JOSHI" wrote: hi there ............... i want to know whther there is any restrictions in excel for filteration ...?? because i have an data of around 12000 lines and if i filter it, it is applying filter upto row no. 5136 .......... 5137 and onwards rows are not filtered (even though i have selected all the 12000 rows while appling filter......... why ?? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet Restrictions | Excel Discussion (Misc queries) | |||
| data restrictions | Excel Discussion (Misc queries) | |||
| How to Add Restrictions to ComboBox...??? | Excel Worksheet Functions | |||
| How to add Restrictions to Combo Box?/ | Excel Worksheet Functions | |||
| How to do look up with restrictions | Excel Discussion (Misc queries) | |||
Linear Mode
