SammySpaceman
Board Regular
- Joined
- Aug 18, 2002
- Messages
- 64
- Office Version
- 2019
- Platform
- Windows
Hi,
I have a list of titles in Column A and a corresponding number in Column HG. I'm trying to use Index/Match to return the titles with the highest numbers. My issue is that some of the titles have the same number. My formula returns the same title for both cells that have the same number, instead of the two or more titles that have that number.
Here's the formula I'm currently using: =INDEX('Full Stats'!$A$3:$A$98,MATCH(B78,'Full Stats'!$HG$3:$HG$98,0))
I've tried creating an Array formula to populate multiple results, but, each time, it only seems to populate the first cell.
This is the formula I've tried =IFERROR(INDEX('Full Stats'!$A$3:$A$98, SMALL(IF($B$78='Full Stats'!$HG$3:$HG$98, ROW('Full Stats'!$HG$3:$HG$98)-ROW('Full Stats'!$HG$3)+1), ROW(1:1))),"" )
I've tried holding Ctrl+Shift+Enter and dragging downwards, but it doesn't seem to do anything. Array formulas are not my area of expertise. Any help is greatly appreciated.
I have a list of titles in Column A and a corresponding number in Column HG. I'm trying to use Index/Match to return the titles with the highest numbers. My issue is that some of the titles have the same number. My formula returns the same title for both cells that have the same number, instead of the two or more titles that have that number.
Here's the formula I'm currently using: =INDEX('Full Stats'!$A$3:$A$98,MATCH(B78,'Full Stats'!$HG$3:$HG$98,0))
I've tried creating an Array formula to populate multiple results, but, each time, it only seems to populate the first cell.
This is the formula I've tried =IFERROR(INDEX('Full Stats'!$A$3:$A$98, SMALL(IF($B$78='Full Stats'!$HG$3:$HG$98, ROW('Full Stats'!$HG$3:$HG$98)-ROW('Full Stats'!$HG$3)+1), ROW(1:1))),"" )
I've tried holding Ctrl+Shift+Enter and dragging downwards, but it doesn't seem to do anything. Array formulas are not my area of expertise. Any help is greatly appreciated.