# Filter Out Top 3 Values Based on Dates

1. ## Filter Out Top 3 Values Based on Dates

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.

https://www.excelforum.com/attachmen...1&d=1618490777

2. ## Re: Filter Out Top 3 Values Based on Dates

Please don't add unnecessary screen shots: a workbook will more than suffice.

3. ## Re: Filter Out Top 3 Values Based on Dates

I thought it would help you guys avoid taking the extra step downloading the file and quickly see everything at a glance to know if that's something you'd be looking into in a first place! Was just trying to make it simpler for you too...

4. ## Re: Filter Out Top 3 Values Based on Dates

The result looks like unique emotions, not TOP 3 emotions.

D34
Formula:
`Please Login or Register  to view this content.`

or Faster but require Ctrl+Shift+Enter at D39
Formula:
`Please Login or Register  to view this content.`

5. ## Re: Filter Out Top 3 Values Based on Dates

oh my... I don't know how it works but it works! thank you, thank you so much Bo_Ry. cannot express in words, grateful! THANK YOU!!!

There are currently 1 users browsing this thread. (0 members and 1 guests)