Hello, I would kindly like your help in ordering the list in the attached file in ascending order by month/yera.
Column D dates
in column Q I grouped them by month but, as you can see, they come in a messy way
I would like them to be sorted according to the numbering you see in column R
So in Q2 it should be April 2019 and not June 2019
Thank you
Why not just sort on column D?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
For Excel2010
Please try at Q2
=IFERROR(AGGREGATE(15,6,$D$2:$D$99/(--TEXT($D$2:$D$99,"yymm")>AGGREGATE(14,6,--TEXT(Q$1:Q1,"yymm"),1)),1),"")
For Excel2007
U2
=IFERROR(SMALL(IF(--TEXT($D$2:$D$99,"yymm")>(MAX(--TEXT(U$1:U1,"yymm"))),$D$2:$D$99),1),"")
and Press Ctrl+Shift+Enter
Ciao Berna11,
a very similar approach to Bo_Ry's one (ความคิดที่ดี!)
=IFERROR(TEXT(AGGREGATE(15,6,D$2:D$100/(DATE(YEAR(D$2:D$100),MONTH(D$2:D$100);1)>Q1+1),1),"MMMM YY"),"")
From an Italian Excel version should be:
=SE.ERRORE(TESTO(AGGREGA(15;6;D$2:D$100/(DATA(ANNO(D$2:D$100);MESE(D$2:D$100);1)>Q1+1);1);"MMMM AA");"")
Warm Regards
Last edited by canapone; 05-05-2019 at 06:24 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Thank you all for your help.
*your Bo_Ry and Canapone solutions
both work properly
Thanks again a greeting.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks