Hi

I'm working in a course proyect. I have a raw report that i need to sub divde in sheets per course, and in every course sheet i need only the courses "passed" and "in progress". At this time i made a formula to bring the selected course to the sheet, but i need to place a filter in te formula to brin only the passed or in progress.

this is the formula that i'm using to bring the courses per sheet

{=IFERROR(INDEX(Report!B$2:B$3156,SMALL(IF(Report!$B$2:$B$1156=$A$2,ROW(Report!B$2:B$1156)-ROW(Report!B$2)+1),ROWS(Report!B$2:Report!B2))),"")}


i try to use (in test sheet A13) {=IFERROR(INDEX(Report!B$2:B$1156,SMALL(IF(IF(OR((Report!$B$2:$B$1156=$B$2)*(Report!$B$2:$B$1156=$D$2)),(Report!$B$2:$B$1156=$A$2),0),ROW(Report!B$2:B$1156)-ROW(Report!B$2)+1),ROWS(Report!B$2:Report!B10))),"")}

but does not work.
test.csv
So a little bit of help will be great