Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet with 5 columns (A-E) and almost 26,000 rows. I found a
problem yesterday when trying to filter a column. I tried to filter out a date of 11/2/2008 and no records were filtered with that date. Other dates work, but in reviewing the drop down list on the header I also noted other dates missing. A review of all records did however, show them present. In an attempt to determine if they were entered incorrectly I sorted by that column and the missing dates show up in date order properly. I've tried re-entering those dates, changing to serial number and back to date and even copied formatting from working rows, but to no avail. Is there a size limit to auto filter? Any suggestions other than putting in Access will be greatly appreciated:) |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
With Excel 2003 and earlier, there is a limit to the number of unique
items that can be displayed in the filter drop-down - this is 1000 unique items. You can still filter by using Custom ... and then selecting Less than, or Greater than etc. For dates, you could put a formula in a helper column which just gave you the month, for example, then by selecting March on that column you would see more of your dates in the filter drop-down of the date column. Hope this helps. Pete On Nov 7, 6:29*pm, dls61721 wrote: I have a spreadsheet with 5 columns (A-E) and almost 26,000 rows. *I found a problem yesterday when trying to filter a column. *I tried to filter out a date of 11/2/2008 and no records were filtered with that date. *Other dates work, but in reviewing the drop down list on the header I also noted other dates missing. *A review of all records did however, show them present. *In an attempt to determine if they were entered incorrectly I sorted by that column and the missing dates show up in date order properly. *I've tried re-entering those dates, changing to serial number and back to date and even copied formatting from working rows, but to no avail. *Is there a size limit to auto filter? *Any suggestions other than putting in Access will be greatly appreciated:) |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Please disregard this post. I broke the cardinal rule and didn't look for
the answer in previous posts/replies. I found my answer and the answer was that the list is populated only by the first 1,000 entries. I can and have now used the custom option in auto filter and the data shows just fine. Please accept my apologies:) "dls61721" wrote: I have a spreadsheet with 5 columns (A-E) and almost 26,000 rows. I found a problem yesterday when trying to filter a column. I tried to filter out a date of 11/2/2008 and no records were filtered with that date. Other dates work, but in reviewing the drop down list on the header I also noted other dates missing. A review of all records did however, show them present. In an attempt to determine if they were entered incorrectly I sorted by that column and the missing dates show up in date order properly. I've tried re-entering those dates, changing to serial number and back to date and even copied formatting from working rows, but to no avail. Is there a size limit to auto filter? Any suggestions other than putting in Access will be greatly appreciated:) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |