+ Reply to Thread
Results 1 to 1 of 1

displaying ranked values that are returned from COUNTIFS

  1. #1
    Registered User
    Join Date
    10-18-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Excel 2010
    Posts
    3

    displaying ranked values that are returned from COUNTIFS

    Hello,

    I am working with a COUNTIFS formula (shown below) and a table of entries found in the 'menu' sheet of the attached file.

    After entering variables in B3:B6 of the 'dashboard' sheet, I sort the rows in the 'decider' sheet according to the number of resulting COUNTIFS matches, relative to the entries in 'menu'. Within each row on 'decider', you will see these matches formatted in green text.

    After sorting the rows in 'decider' according to COUNTIFS matches, I am looking for a way for the 'dashboard' sheet to display 1) these matches, and 2) the "menu" labels that they most closely correspond to from the 'menu' sheet.

    I have included an example on the 'dashboard' sheet of what my ideal table should look like. Is there any way for this COUNTIFS formula to work with SMALL or RANK functions?:

    =COUNTIFS(menu!$B$2:$B$500,">"&(1-((dashboard!$B$5)/100))*tabs!I2,menu!$B$2:$B$500,"<"&(1+((dashboard!$B$5)/100))*tabs!I2)>0

    Thanks for any help you can provide!
    Attached Files Attached Files

+ 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] Countifs displaying #Value
    By avien in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-31-2013, 10:13 AM
  2. Replies: 2
    Last Post: 02-05-2013, 04:52 AM
  3. Sum ranked values in nonadjacent cells
    By mashley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2007, 07:42 PM
  4. summing previously ranked values
    By ellebelle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2006, 12:30 PM
  5. [SOLVED] RE: summing previously ranked values
    By ellebelle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2006, 09:37 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