tracking account statements - excel

[Alina_T]

Hello! Please help me with another issue - first of all, thanks a lot for the support founded here
I have to track the account statements, some of clients don't send the right papers and we have to remind them all the time. So, I have these records and based of them I have to go on a result then put it on a mail.
The formula, if there is one, should put the result based on the month I will check the excel - that's way I've put two columns with 2 examples. But I need only one column with all the months missing.

maybe I want a unicorn, but I have to try on you, guys

Thank a lot!

 

[bosco_yip]

Try,

1] "Result for month June (Today)" in cell P2, array (CSE) formula copied down :

=TEXTJOIN(", ",,IF(D2:INDEX(D2:O2,MATCH(TEXT(TODAY(),"mmmm"),D$1:O$1,0))="",D$1:INDEX(D$1:O$1,MATCH(TEXT(TODAY(),"mmmm"),D$1:O$1,0)),""))

2] "Result for month August" in cell O2, array (CSE) formula copied down :

=TEXTJOIN(", ",,IF(D2:INDEX(D2:O2,MATCH(TEXT(TODAY(),"mmmm"),D$1:O$1,0)+2)="",D$1:INDEX(D$1:O$1,MATCH(TEXT(TODAY(),"mmmm"),D$1:O$1,0)+2),""))

 

[Alina_T]

omg!! you're a life saver! thank you so much! I realize how little I am in excel knowledge...
it works perfectly! thank you!!!!