| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel filter won't capture everything in the column - why?
I have filtered a column called Programs. When I open the filter to view the
programs it isn't capturing all of them in the column. I have retyped the programs that are missing, and still it won't show. Any ideas or suggestions? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel filter won't capture everything in the column - why?
If you have more than a 1000 unique entries, then that's just the way excel
works. You can only see the first 1000 unique entries using the dropdown. You can still use a custom filter to show the rows with the other values. Debra Dalgleish has some work-arounds that you may want to try: http://contextures.com/xlautofilter02.html#Limits The_Warden wrote: I have filtered a column called Programs. When I open the filter to view the programs it isn't capturing all of them in the column. I have retyped the programs that are missing, and still it won't show. Any ideas or suggestions? Thanks! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel filter won't capture everything in the column - why?
Thank you very much. What a frustration! Hopefully they'll figure that
problem out for the next version! "Dave Peterson" wrote: If you have more than a 1000 unique entries, then that's just the way excel works. You can only see the first 1000 unique entries using the dropdown. You can still use a custom filter to show the rows with the other values. Debra Dalgleish has some work-arounds that you may want to try: http://contextures.com/xlautofilter02.html#Limits The_Warden wrote: I have filtered a column called Programs. When I open the filter to view the programs it isn't capturing all of them in the column. I have retyped the programs that are missing, and still it won't show. Any ideas or suggestions? Thanks! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel filter won't capture everything in the column - why?
"They" haven't fixed it for the past several versions.
It is not viewed as a problem apparently. Gord Dibben MS Excel MVP On Wed, 14 May 2008 08:23:07 -0700, The_Warden wrote: Thank you very much. What a frustration! Hopefully they'll figure that problem out for the next version! "Dave Peterson" wrote: If you have more than a 1000 unique entries, then that's just the way excel works. You can only see the first 1000 unique entries using the dropdown. You can still use a custom filter to show the rows with the other values. Debra Dalgleish has some work-arounds that you may want to try: http://contextures.com/xlautofilter02.html#Limits The_Warden wrote: I have filtered a column called Programs. When I open the filter to view the programs it isn't capturing all of them in the column. I have retyped the programs that are missing, and still it won't show. Any ideas or suggestions? Thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
| Auto Filter - capture criteria used | Excel Discussion (Misc queries) | |||
| capture last cell in column | Excel Discussion (Misc queries) | |||
| Capture and list data from a column or row | Excel Worksheet Functions | |||
| Capture event when exit Column G | Excel Discussion (Misc queries) | |||
Linear Mode
