copy paste below in H6 and then hold control and shift together and then hit enter and drag down to make it array formula
=IFERROR(INDEX($B$3:$B$34,MATCH(SMALL(IF(($E$3:$E$34="M")*($C$3:$C$34),$C$3:$C$34),ROW(A1)),$C$3:$C$34,0)),"")
copy paste below in P6 and then hold control and shift together and then hit enter and drag down to make it array formula
=IFERROR(INDEX($B$3:$B$34,MATCH(SMALL(IF(($E$3:$E$34="F")*($C$3:$C$34),$C$3:$C$34),ROW(A1)),$C$3:$C$34,0)),""
copy paste below in L6 and then hold control and shift together and then hit enter and drag down to make it array formula
=IFERROR(INDEX($B$3:$B$34,MATCH(LARGE(IF(($E$3:$E$34="M")*($D$3:$D$34),$D$3:$D$34),ROW(A1)),$D$3:$D$34,0)),"")
copy paste below in T6 and then hold control and shift together and then hit enter and drag down to make it array formula
=IFERROR(INDEX($B$3:$B$34,MATCH(LARGE(IF(($E$3:$E$34="F")*($D$3:$D$34),$D$3:$D$34),ROW(A1)),$D$3:$D$34,0)),"")
..confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Bookmarks