Hi guys, this isn't one out of a box, just no longer have any ideas how to make it work, wonder if you'd know of any possible ways going about it?
As a screenshot shows, I've months marked as Mo1, Mo2, Mo3 etc (these needs to stay marked in this way) And then in Data tab I've emotions that are entered next to dates.
The outcome I'm looking to achieve is that a system should filter out TOP 3 emotions for that one specific month (where the first earliest date entered in Data tab would be Mo1, and following dates would fall into Mo2, Mo3 etc columns)
The correct end result is already entered in D39:F41 but that's just type, not formulas. Do you know what formulas could be used here?
-----
A member Bo_Ry helped to build the following formula the other day (thank you!!!), but this was to serve the other purpose, to sum up values based on Months (Mo1, Mo2 etc), dates & values. So maybe this same formula could also be optimised to help achieve the new, different outcome as per above details?
=SUMIFS(Data!$BV$11:$BV$19,Data!$BU$11:$BU$19,">"&EOMONTH(MIN(Data!$BU$11:$BU$19),MID(D33,3,2)-2),Data!$BU$11:$BU$19,"<="&EOMONTH(MIN(Data!$BU$11:$BU$19),MID(D33,3,2)-1))
-----
Also attaching the file below.
Thanking in advance!
https://www.excelforum.com/attachmen...1&d=1618490777
Bookmarks