Get Cell value from adjacent cell if it has specific number or Text - 1 in given case

[analystbank]

Sample Excel workbook is attached (version 1997-2000)

I have Table of Students in Range A1:L209 (this could extend to 250 or 300 or so, but currently 209 only)

Column A has Student name

Column B to J has some other values retrieved through formulas from other worksheet within same workbook. (perhaps not relevant for this query)

Column K has header 'Passed' for which value 1 is assigned through formula against respective student who have passed
Column L has header 'Failed' for which value 1 is assigned through formula against respective student who have failed

I want a small tabulation for both categories of students (all those) who have passed and failed separately


All Those who have passed - Starting from Cell O28
All Those who have failed - Starting from Cell O47


Column P to S i will populate once i get the name using Index/Match Concept.


I have filled the O28 and O47 table just to show how it should look like for understanding purpose.