Results 1 to 11 of 11

Index Match Large Duplicate Values

Threaded View

  1. #1
    Registered User
    Join Date
    08-20-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    8

    Index Match Large Duplicate Values

    Hi,

    I cannot return each corresponding fruit to each largest price in below table.
    I have been trialing with Index, Match, Vlookup, and Row and keep failing even with a helper column Countif because I have duplicate values
    Checked out these old threads as well and have not been able to replicate the correct results.

    What am I missing?

    Original data:
    Apple 10
    Orange 11
    Strawberry 9
    Pear 5
    Banana 10

    Analysed data (using Large() fyi, cannot use Max for other reasons):

    ? 11
    ? 10
    ? 10
    ? 9
    ? 5


    Thanks for any help,

    http://www.mrexcel.com/forum/excel-q...g-results.html

    http://www.mrexcel.com/forum/excel-q...te-values.html
    Last edited by auxaurores; 09-11-2016 at 01:56 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Match and Index with Duplicate values
    By shortracer5 in forum Excel General
    Replies: 1
    Last Post: 09-09-2016, 05:25 AM
  2. [SOLVED] Handling Duplicate Entries with Index/Match/Large in Column Data
    By TwiceBorn in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-12-2016, 02:11 PM
  3. Index Match & Duplicate values
    By Shaulyt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2016, 05:23 PM
  4. [SOLVED] INDEX, MATCH & LARGE trouble with duplicate values
    By paulstuartbullock in forum Excel General
    Replies: 4
    Last Post: 08-04-2015, 11:17 PM
  5. Index Match with Duplicate Values
    By js2178a in forum Excel General
    Replies: 2
    Last Post: 09-28-2014, 02:21 AM
  6. [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
  7. Index, Match, Large Function returning duplicate names
    By RNeel55 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2013, 04:09 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