Forum Discussion
clh_1496
Aug 03, 2023Brass Contributor
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...
- Aug 08, 2023
How about this version (Excel in Microsoft 365/Office 2021/Online):
HansVogelaar
Aug 03, 2023MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?