Forum Discussion

P DS's avatar
P DS
Copper Contributor
Jul 10, 2017
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...
excel
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    Jul 10, 2017

    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. 

IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Jul 10, 2017

Sergei, I can confirm that the workaround you posted does not resolve the issue when it occurs. You can see in the attached screenshot that the filter does not find the dates, even though they are present in the column.  You may not be able to reproduce the issue, but that does not mean that it doesn't exist for others. 

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 10, 2017

Ingeborg, please try 06 instead of June. Search filter for such cases works with date format string.

 

 

 

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 10, 2017

    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.

Resources