print days of min price per months

[garbanna]

Hi all,

I have attached excel file with described case.
I have Date and Price data and want to get min price days for every year and month. I was able to find min value per month using minifs with additional table.

but I cannot print days from these months where min price is. If I use TextJoin. I will try to post more details if I be allowed. sorry for being newbie.

I appreciate any advice or help.

[RaulSerg]

Try this: =TEXTJOIN(", ",TRUE,IF((K2=B2:B121)*(D2:D121=MONTH(I2)),C2:C121,""))

Alternatively: =TEXTJOIN(", ",TRUE,FILTER(C2:C121,(K2=B2:B121)*(D2:D121=MONTH(I2)),""))

[garbanna]

first case returned all days, the second didn't accept formula due to "filter", I believe it can be my used office 2019 feature limits, because when I tried them on 365, it worked properly. confusing.
thank you RaulSerg, at least it works on 365, looks like I need to plan to upgrade, but I believe it should be the way to get the same results with older excel version as well.

[RaulSerg]

Hmm, maybe try to array enter the first formula then with Ctrl+Shift+Enter