Forum Discussion

clh_1496's avatar
clh_1496
Brass Contributor
Aug 03, 2023
Solved

INDEX, MATCH for largest scores combined with specific criteria within the names

Hi   I have this formula that brings through 5 names based on the top 5 largest scores. =INDEX('Top CV'!$C$5:$C$24,MATCH(SMALL('Top CV'!$A$5:$A$24,1),'Top CV'!$A$5:$A$24,0)) The issue is that I n...

Resources