Forum Discussion
Solved
Custom Sorting - can you apply it to filters?
I have a column which is Week number (based on WEEKNUM calculation). Excel reads this as a text field and so Week 1 is arranged after Week10 etc. To fix this in the table I created a custom sort list...
If you return Week Number as
="Week " & WEEKNUM(E7,2)you may use
="Week " & TEXT( WEEKNUM(E7,2), "00" )instead
If you return Week Number as
="Week " & WEEKNUM(E7,2)you may use
="Week " & TEXT( WEEKNUM(E7,2), "00" )instead
Ah yes that worked perfectly, thank you for your help!! 🙂
stacey197 , you are welcome