Results 1 to 3 of 3

How to return top values based on cell criteria?

Threaded View

AccountingJ How to return top values... 10-01-2021, 03:10 PM
Bo_Ry Re: How to return top values... 10-01-2021, 03:35 PM
AccountingJ Re: How to return top values... 10-01-2021, 03:42 PM
  1. 10-01-2021, 03:10 PM #1
    AccountingJ is offline
    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.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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. Return multiple cell values(text) based on text criteria
    By bigTop in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1