Results 1 to 3 of 3

Index Match with Duplicate Values

Threaded View

js2178a Index Match with Duplicate... 09-27-2014, 11:29 PM
AlKey Re: Index Match with... 09-27-2014, 11:49 PM
canapone Re: Index Match with... 09-28-2014, 02:21 AM
  1. #1
    Registered User
    Join Date
    09-27-2014
    Location
    New York
    MS-Off Ver
    2010
    Posts
    1

    Index Match with Duplicate Values

    I am trying to get different information from duplicate values. I am looking to get names from duplicate numbers based off of a master list of numbers. Here is the formula I have been using but it is not working correctly:
    {=INDEX(B$2:B$3270,SMALL(IF(MATCH(J2,A$2:A$3270,0),ROW($A2:$A3270)),COUNTIF(J$2:J2,J2)))}
    I attached the file as it is easier to see there.
    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. [SOLVED] Help with Index/Match/Large problem with duplicate values
    By enphynity in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-31-2013, 09:56 AM
  2. index match with duplicate values - how to get latest value
    By helpme10 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-29-2013, 02:13 PM
  3. [SOLVED] Index and match functions for duplicate values
    By JBERK in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-23-2012, 10:48 AM
  4. Index/Match where data has duplicate values
    By ragatha in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-06-2012, 12:09 PM
  5. Excel, Match/Index when duplicate values?
    By Fizziii in forum Excel General
    Replies: 0
    Last Post: 01-18-2011, 02:12 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