Forum Discussion
Solved
Excel filter issues
Hi I have an excel file with dates (month) from 01/07/2016 to 30/05/2017. Excel is only filtering the top 4 months on the list. (everytime I sort the date, either from oldest to newest or vice vers...
Sergei, the Excel version 1706 has a known problem with filters. It has been reported to the Excel developers. Search filters will not help in this scenario, because Excel does not include some date ranges in the filter in the first place. The search only searches in what the filter already includes. If the filter does not include it, it cannot be discovered by search.
SergeiBaklan Yes, it finds the dates. Still, the list not showing all the dates is a bug.
IngeborgHawighorst, I agree that's a bug, all dates in the list are calculated as unique ones, thus have 10000 limit. I only gave possible workaround.