Quote Originally Posted by Glenn Kennedy View Post
Scratch that... You're right XOR LX (of course!! - how could I even have considered any other possibility...)
You probably began with the INDEX part as an alternative to CSE and only realised later down the line that CSE was in fact required!

If you really want to avoid CSE:

=IFERROR(LARGE(IF(N(INDEX($A$2:$A$13=$I$5,0)),INDEX($B$2:$E$13+1/(COLUMN(B$2:E$13)*10^8),0)),ROWS($1:1)),"")

or:

=IFERROR(LARGE(IF(MMULT(0+($A$2:$A$13=$I$5),1),INDEX($B$2:$E$13+1/(COLUMN(B$2:E$13)*10^8),0)),ROWS($1:1)),"")

though these are arguably unnecessarily convoluted and certainly more resource-heavy than the equivalent CSE version.

In fact, I personally gave up this practice of artificially inserting one or more INDEX functions for the sake of avoiding CSE once I realised that they rendered the construction more resource-heavy. That and the fact that I also believe we should be doing our best to promote array-formula use, rather than encourage its avoidance (there's enough unfounded 'fear' of array formulas out there as it is...)

Regards