filtering by date

Occasional Visitor

I have a problem auto filtering by date and year.

In version MS Excel for Microsoft 365 MSO (16.013801.21004) 32 bit I was able to filter a csv file.

In the date column it would automatically group by year. No intervention required.

 

In this new version it would run a wizard and it would not filter and group by year. This version is MS Excel for Microsoft 365 MSO(Version 2022 Build 16.0.14931.20118) 32bit

 

Are there any know issues or work arounds for this.

0 Replies