+ Reply to Thread
Results 1 to 5 of 5

Filter Out Top 3 Values Based on Dates

  1. #1
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    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.

    Thanking in advance!

    https://www.excelforum.com/attachmen...1&d=1618490777
    Attached Files Attached Files
    Last edited by AliGW; 04-15-2021 at 09:04 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,991

    Re: Filter Out Top 3 Values Based on Dates

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

  3. #3
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    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. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Filter Out Top 3 Values Based on Dates

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

    Please try at
    D34
    Formula: copy to clipboard
    Please Login or Register  to view this content.


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

  5. #5
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    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!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA - Auto Filter and make new sheets based on the filter values- Loop
    By Paul Cherian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2017, 06:41 AM
  2. VBA to filter by dates, return values only if between certain dates
    By Simon.xlsx in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-25-2015, 10:08 AM
  3. Trying to make a filter list based on dates
    By siukingyiu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 01:40 PM
  4. [SOLVED] TextBox values as filter criteria - dates
    By MKrop in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-09-2013, 03:49 AM
  5. Filter Based on Dates
    By rau in forum Excel General
    Replies: 1
    Last Post: 07-02-2013, 07:30 PM
  6. Replies: 2
    Last Post: 01-20-2012, 08:19 AM
  7. filter list on new sheet based on due dates
    By AdamK in forum Excel General
    Replies: 2
    Last Post: 09-15-2010, 04:53 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1