Hi Excel Forum,
I have a column of cells with months that are out of order.
E.g: "January October November December March April May February June July August September"
Does anyone know of a quick way to sort these by month?
I found this user defined function which sorts by number:
https://superuser.com/questions/7051...-cell-in-excel
Please Login or Register to view this content.
Many Thanks
How about this, for a list of months in A2:
=LET(v,TEXTSPLIT(A2," "),d,DATEVALUE(v & " 1, 2023"),s,SORT(TRANSPOSE(d),1),TEXTJOIN(" ",FALSE,TEXT(TRANSPOSE(s),"mmmm")))
You can then copy the formulas and paste values over the original cells.
Ooops - sorry. Getting too used to everyone having 365....
Change your function to this:
Please Login or Register to view this content.
Last edited by Bernie Deitrick; 01-19-2023 at 04:40 PM.
Bernie Deitrick
Excel MVP 2000-2010
try
Please Login or Register to view this content.
Thank you very much Bernie and Jindon! Both of these responses work perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks