Forum Discussion
How can I avoid duplicate values being returned with INDEX MATCH?
I'm trying to return the top 10 worst percentages with a LARGE function, and then in an adjacent column, use the INDEX MATCH functions to return which question correspon...
=INDEX($A$1:$A$27,MATCH(1,($B$1:$B$27=F2)*($C$1:$C$27=E2),0))You can try this formula along with helper columns. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=COUNTIF($B$1:B1,B1)This is the formula in cell C1 in the example.
In column F is the LARGE function and column E is another COUNTIF which counts the values of column F.