Results 1 to 12 of 12

Index Match Array returning duplicate values

Threaded View

Dreadpiraterai Index Match Array returning... 12-14-2023, 08:36 AM
chris01395 Re: Index Match Array... 12-14-2023, 09:23 AM
Dreadpiraterai Re: Index Match Array... 12-14-2023, 09:35 AM
chris01395 Re: Index Match Array... 12-14-2023, 09:41 AM
JeteMc Re: Index Match Array... 12-16-2023, 11:21 AM
windknife Re: Index Match Array... 12-16-2023, 01:37 PM
Dreadpiraterai Re: Index Match Array... 12-18-2023, 04:30 AM
AliGW Re: Index Match Array... 12-18-2023, 04:41 AM
AliGW Re: Index Match Array... 12-18-2023, 05:11 AM
Dreadpiraterai Re: Index Match Array... 12-18-2023, 08:06 AM
AliGW Re: Index Match Array... 12-18-2023, 08:37 AM
Dreadpiraterai Re: Index Match Array... 12-18-2023, 09:59 AM
  1. #1
    Registered User
    Join Date
    12-13-2023
    Location
    England
    MS-Off Ver
    2016
    Posts
    5

    Index Match Array returning duplicate values

    Hi all,

    First post so here goes. I'm attempting to return the column name for the three lowest values in a set. At the moment if two values are the same it is duplicating and returning the first value, which I don't want. I need it to return three unique column names.

    Example.png

    My current Array is

    {=INDEX(E5:L5, MATCH(SMALL(E6:L6,{1;2;3}), E6:L6,0))}
    Where E5:L5 are the column headers and E6:L6 are the values.

    Any help would be appreciated. I'm currently using the 2016 version of office.

    Crossposted: stackoverflow.com/questions/77665366/problems-with-index-match-array-returning-duplicates
    Attached Files Attached Files
    Last edited by Dreadpiraterai; 12-18-2023 at 10:04 AM. Reason: Addition of crossposting

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] my index and match formula is returning duplicate entries
    By FrancisM2411 in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 01-17-2024, 01:03 PM
  2. INDEX MATCH Returning Duplicate Results
    By Freekindasheets in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-26-2023, 08:26 AM
  3. [SOLVED] index match returning duplicate values
    By chriswrcg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2022, 09:38 AM
  4. [SOLVED] Sum duplicate values returned by array formula INDEX(MATCH(LARGE(IF)))
    By TFiske in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-02-2017, 07:18 PM
  5. Replies: 2
    Last Post: 03-15-2017, 08:22 AM
  6. match/index fomula returning duplicate values.
    By maximus0120 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2012, 07:24 PM
  7. Replies: 8
    Last Post: 06-29-2012, 10:20 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