Hi Ford,
Thank you for solution. However it's not working properly. I want to match the subject on summary sheet '$m$4'. If there is 'Marathi' subject in m4 then all the top students for Marathi subject should be retrieve from 'Data' sheet on 'Summary' sheet automatically. and not the students for other subjects which didn't match cell 'm4' on 'Summary' sheet.

Please do the amendment in the array formula to achieve the target.

Thank you.