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
Bookmarks