Thank you. With slight amendments they seem to work OK
Formula:
=IFERROR(INDEX('Actual vs School Table'!$E$4:$E$11,SMALL(IF('Actual vs School Table'!$A$4:$A$11='Actual vs School Table'!$C$4:$C$11,ROW('Actual vs School Table'!$A$4:$A$11)-ROW('Actual vs School Table'!$A$4)+1),ROWS(A$4:A5))),"")
and
Formula:
=IFERROR(INDEX('Actual vs School Table'!$E$4:$E$11,SMALL(IF('Actual vs School Table'!$A$4:$A$11='Actual vs School Table'!$C$4:$C$11,ROW('Actual vs School Table'!$A$4:$A$11)-ROW('Actual vs School Table'!$A$4)+1),ROWS(A$4:A4))),"")
Trouble is it does not seem to make any sense whatsoever. The first one (cell C4) requires an amendment to
Formula:
-ROW('Actual vs School Table'!$A$4)+1),ROWS(A$4:A5)
to return the correct result whereas
Formula:
-ROW('Actual vs School Table'!$A$4)+1),ROWS(A$4:A4)
works. This appears to be the reverse of what I would expect. Can you explain please because I will need to transpose these formulas into the real much bigger spreadsheet.
Bookmarks