Hello,
I have a table with that populates per score per company
A1:E1 46, 46, 59, 63, #DIV!/0
A2:E2 Company 1,Company 2, Company 3, Company 4, BLANK
I wanted to use INDEX($A$2:$E$2,1,COLUMN(AGGREGATE(15,6,$A$1:$E$1,1))) to ignore errors and find the smallest value, return the respective company name.
But it does not seem to catch the column number using this formula.
I want to display this on a separate table where I would call out top 2 and bottom two scorers so I need to make sure it will still work if two companies share the same score.
What am I doing wrong?
Bookmarks