Autofilter does not show values from 2022

Deleted
Not applicable

Excel for Mac v.16.65

 

I have a long list with dates and times in column "Datum och tid", from 2020 to 2022

 

When I use autofilter on this column, autofilter only displays the values from 2020 and 2021

 

Any idea how I can solve this? Some error in Excel that is never solved by Microsoft

 

Skärmavbild 2022-09-14 kl. 10.22.18.png

1 Reply

I suspect you have an empty row above the row where the dates from 2022 begin. Delete it and try again.