Results 1 to 10 of 10

Problem Using LARGE formula with Index/Match to pull values when there are Duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    07-18-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    48

    Problem Using LARGE formula with Index/Match to pull values when there are Duplicates

    Good Morning,

    I am attempting to use the LARGE formula to pull the top 3-5 percentages out of a field of 50-100, while using the INDEX/MATCH function to pull the corresponding "descriptor" that is associated with those top 3-5 percentages. (I need to do this across multiple data sets, but I can't get past this 'duplicate' issue) However, I am running into the problem when there are 2 percentages that are identical (WH 14 and WH 16 in pasted text below), then the INDEX/MATCH function only pulls the 1st "descriptor" and doesn't continue down to the Duplicate. I am stuck as to how to tell excel to move to the next set of duplicate data and match the 'descriptor' to that data? I appreciate any/all help!

    I have attached a file that should show what I am trying to do. These are the formulas I am using right now, pulled down into the 3 cells below them to get the top 3.

    B1:
    =LARGE(B50:B65,1)
    C1:
    =INDEX(A50:A65,MATCH($B$3,B50:B65,0))

    Warehouse S/S %
    WH 1 50.00%
    WH 2 57.14%
    WH 3 0.00%
    WH 4 50.00%
    WH 5 100.00%
    WH 6 60.00%
    WH 7 33.33%
    WH 8 66.67%
    WH9 60.00%
    WH 10 63.64%
    WH 11 78.57%
    WH 12 55.56%
    WH 13 42.86%
    WH 14 71.43%
    WH 15 61.54%
    WH 16 71.43%
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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