Forum Discussion

jbkalla's avatar
jbkalla
Copper Contributor
Feb 13, 2023
Solved

Excel 2016 INDEX MATCH fixing duplicate entries

I'm trying to rank order entries using INDEX MATCH, and it's working, but when there are duplicate values, it only returns the first entry (note the duplicates "General Question" and "Capability Requ...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Feb 13, 2023

    jbkalla 

    =INDEX($A$2:$A$10,MATCH(TRUE,($B$2:$B$10=LARGE($B$2:$B$10,ROW(E1))*(COUNTIF($F$1:F1,$A$2:$A$10)=0)),0))

    You can try this formula. Enter the formula with ctrl+shift+enter as an arrayformula.

     

Resources