Results 1 to 9 of 9

Advanced INDEX/MATCH Formula - is this possible?

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2015
    Location
    Columbus, Ohio
    MS-Off Ver
    2013
    Posts
    13

    Lightbulb Advanced INDEX/MATCH Formula - is this possible?

    I've been using Azumi's formula for almost a year now on a production report that I manage daily for my firm.
    This formula has helped me create a "Top Producer" functionality for my report.
    Things have gotten more complicated and now I'm wondering if there is a way to take this formula a step further.
    We have a lot more employees so I'm finding more and more instances where there are "ties" that occur.
    For example, two employees will end the week with a score of 34 and 34, creating a need for a tiebreaker.
    I want the tiebreaker to be volume of goods sold.

    Here are the two formulas in E2 and G2 that work together to display the employee with the most points. If there is a tie, it will list the employee highest up on the sheet.

    =IF(ROWS($A$1:A1)<=3,INDEX($A$8:$A$24,MATCH(LARGE(INDEX($B$8:$B$24+(ROWS($B$8:$B$24)-ROW($B$8:$B$24))/10^5,0),ROWS(A$1:A1)),INDEX($B$8:$B$24+(ROWS($B$8:$B$24)-ROW($B$8:$B$24))/10^5,0),0)),"")

    =LARGE(B6:B15,1)


    Attachment 457767


    Is there a way to further advance this formula so that first, it arranges the top producers based upon Score, and then by Volume?
    So in the case shown here, it would display Brian, then Ryan, and finally Joseph?
    Please see the attached file for reference.

    If you need me to go further in detail, please let me know.
    I really appreciate the help! This would be a huge improvement for my report.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Advanced If or Match(index) vba... not really sure.
    By TexasBobcat in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-04-2015, 03:09 PM
  2. Replies: 3
    Last Post: 01-16-2015, 03:59 PM
  3. Using "Index & match" Formula but in an advanced way can anyone help please???
    By knight_craig in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2014, 04:39 AM
  4. [SOLVED] Advanced Match Help (possibly Index Match)
    By dfxryanjr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-08-2013, 09:13 AM
  5. Replies: 7
    Last Post: 08-10-2010, 04:05 PM
  6. advanced lookup/index-match problem
    By tx12345 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2006, 12:40 PM
  7. advanced lookup/index-match problem
    By tx12345 in forum Excel General
    Replies: 1
    Last Post: 08-10-2006, 11:50 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