+ Reply to Thread
Results 1 to 2 of 2

Conditional MIN and RANK using dynamic array formulas

  1. #1
    Forum Contributor
    Join Date
    08-20-2011
    Location
    Oslo
    MS-Off Ver
    MS 365
    Posts
    166

    Conditional MIN and RANK using dynamic array formulas

    Hi,

    I have a data set with a min_range and want to find the smallest values conditional on criteria_range1, criteria_range2 and criteria_range3. Then I want to rank the resulting smallest values in ascending order conditional on criteria_range1. The ranking must give the same rank to ties and then increase the next rank incrementally by 1. I want to accomplish this with a single formula that yields a dynamic array as output. Please see attached workbook.

    Best regards,
    Marbleking
    Attached Files Attached Files
    Last edited by Marbleking; 05-07-2021 at 07:13 AM.

  2. #2
    Forum Contributor
    Join Date
    08-20-2011
    Location
    Oslo
    MS-Off Ver
    MS 365
    Posts
    166

    Re: Conditional MIN and RANK using dynamic array formulas

    Any suggestions for this one?

+ 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. [SOLVED] Conditional MAX and RANK of 18-digit text numbers using dynamic array formulas
    By Marbleking in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-06-2021, 07:41 AM
  2. RANK, SMALL formulas inside the array argument (no CTRL+SHIFT+ENTER)
    By ExcelQuestion in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2019, 08:09 AM
  3. Change Array formulas to make them Dynamic
    By julhs in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-09-2017, 09:01 AM
  4. Dynamic ranges in array formulas.
    By smatchymo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2016, 07:59 AM
  5. [SOLVED] Rank with conditional array
    By Bob Macregor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-26-2014, 12:22 PM
  6. [SOLVED] Dynamic Search function using array formulas
    By adelcap in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2012, 05:46 AM
  7. Can you create dynamic named ranges containing array formulas?
    By Marie J-son in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2006, 09:10 AM

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