+ Reply to Thread
Results 1 to 3 of 3

How to return top values based on cell criteria?

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    How to return top values based on cell criteria?

    Hello again everyone - I have a conditional formatting rule that highlights the top 13 values.

    What I would like is to return the dates for those top values but for it to depend on cell H3. Sometimes we would need to return top 5 etc.

    I looked into the max/large functions and they don't appear to be what I need since they limit me to one result vs the number in cell H3. Any ideas on what function can do the job?
    Attached Files Attached Files
    Last edited by AccountingJ; 10-01-2021 at 03:42 PM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: How to return top values based on cell criteria?

    Please try at H7

    =IF(ROWS(H$7:H7)>$H$3,"",MOD(AGGREGATE(14,6,ROUND($C$7:$G$36*10^15,-6)+$B$7:$F$36/($B$7:$F$36>=$B$3),ROWS(H$7:H7)),10^6))
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    Re: How to return top values based on cell criteria?

    Thank you, this works but I don't understand it and I would like to.

+ 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. To return values based on criteria
    By suji01 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2020, 08:11 PM
  2. [SOLVED] Return several values based on 1 criteria
    By kenjcd in forum Excel General
    Replies: 8
    Last Post: 05-14-2019, 10:57 PM
  3. Return a list of cell values based on criteria in other columns
    By Mikeyd74 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-16-2015, 10:02 AM
  4. Replies: 3
    Last Post: 12-03-2014, 05:43 PM
  5. [SOLVED] How to return multiple values to a single cell based on multiple criteria
    By lwallace in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2014, 06:32 AM
  6. matching values based on criteria and return values from another columns
    By lizard54 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 11:29 AM

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