+ Reply to Thread
Results 1 to 1 of 1

Duplicate values returned using Index Match Lookup with Small()

  1. #1
    Forum Contributor
    Join Date
    10-16-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003, 2010
    Posts
    151

    Duplicate values returned using Index Match Lookup with Small()

    Greetings All

    I am trying to build a set of dashboard Top 10 and Bottom 10 charts and used the Large() and Small() functions to select the top and bottom sets of values. So far, so good, but then in order to put names with the values, I used an Index(Match()) combination and I have 3 values in my sample data that are the same but have different Names associated with them.

    I feel as though there must be a way to get the unique names associated with the duplicated values but I am evidently missing something.

    Any help would be greatly appreciated.

    Thanks
    Attached Files Attached Files
    Jacob Albers
    Excel 2003 & 2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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