Results 1 to 3 of 3

Index/Match for Repeating Values in 2007

Threaded View

  1. #1
    Registered User
    Join Date
    11-15-2010
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Index/Match for Repeating Values in 2007

    Hi all,

    I consider myself a pretty average Excel user, but I can't for the life of me figure this out. I'm using INDEX/MATCH like so:

    Table 1:
    "Data"
    Col A....Col I
    N1.........11
    N2.........10
    N3.........11
    N4..........8
    and so on

    Table 2:
    "Top 5 values:" (picks top 5 values from column I in Table 1 using LARGE functions)
    11....N1
    11....N1 (should be N3)
    10....N2
    8......N4
    and so on

    As shown here, when there are repeat values, it will just take the first name it finds from column A. How can I edit the formula so it won't repeat the value, and will go on to the next value? Examples of the formulas I'm using in Table 2:

    =INDEX(A:A,MATCH(A21,I:I,0)) - this correctly outputs "N1"
    =INDEX(A:A,MATCH(A22,I:I,0)) - this outputs "N1," should be "N3"

    Thanks in advance for your help!

    Chris
    Last edited by jetsfan23; 11-15-2010 at 04:10 PM.

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