Try.. in B24
=IFERROR(INDEX(B$4:B$19,SMALL(IF(($D$4:$D$19=$L$3)*($F$4:$F$19=$L$5)*($E$4:$E$19=$L$7),ROW($A$4:$A$19)-ROW($A$4)+1,""),ROWS($A$4:A4))),"")
Enter with Ctrl+Shift+Enter
Then copy across and down
Try.. in B24
=IFERROR(INDEX(B$4:B$19,SMALL(IF(($D$4:$D$19=$L$3)*($F$4:$F$19=$L$5)*($E$4:$E$19=$L$7),ROW($A$4:$A$19)-ROW($A$4)+1,""),ROWS($A$4:A4))),"")
Enter with Ctrl+Shift+Enter
Then copy across and down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks