-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
filter order by date
- Thread starter uwmarkyo
- Start date
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 9,254
- Office Version
- 365
- Platform
- Windows
What happens if you
• move it from the Filter section to the row section.
• sort it ascending
• move it back to the Filter section
If that doesn't work, if you right click on the field and to to Field settings, it the Number Format button available in the bottom left corner or missing.
If missing then your underlying data is most likely text and not a number OR you have blanks (missing date) in the date column.
@Cubist - its sorting by month and ignoring the year. Sample screen is a bit too limited but I would think it is sorting alpahabetically and not by actual month.
• move it from the Filter section to the row section.
• sort it ascending
• move it back to the Filter section
If that doesn't work, if you right click on the field and to to Field settings, it the Number Format button available in the bottom left corner or missing.
If missing then your underlying data is most likely text and not a number OR you have blanks (missing date) in the date column.
@Cubist - its sorting by month and ignoring the year. Sample screen is a bit too limited but I would think it is sorting alpahabetically and not by actual month.
Last edited:
Upvote
0
Similar threads
- Question
- Solved
