How to automatically extract data in this case

I am working on a workbook that automatically extracts the list of students that are failed after every shool year. The details are in the file attached. To be clear, the sheet named "Failed" will automatically scan the information of every student in the sheet named "Data", and then extract, fill the detailed information (Name, Class, School, Attendance, Attitude, Reading Mark, Writing Mark, Speaking Mark) of the students that are failed.

I don't know if the Excel fomulea could do that or have to use VBA to solve that problem. I don't know VBA so I prefer to use of formulea.

Could any one help me?

Thanks.

Hi,

Have a look at this, in your students sheet i have inserted a helper column that sets "PASSED" or "FAILED" value.

In the "Failed" sheet i have placed a button, when you press it, it will return students that have failed.

Dear Steffen Thomsen,

Thank you so much for your help!

I wonder if we could make the VBA marco just fills in the Sheet named "Failed" the values, not formulea extracted from the sheet named "Data"? It works like the function Copy and Paste Values.

Best Wishes!

Originally Posted by wowow

I am working on a workbook that automatically extracts the list of students that are failed after every shool year. The details are in the file attached. To be clear, the sheet named "Failed" will automatically scan the information of every student in the sheet named "Data", and then extract, fill the detailed information (Name, Class, School, Attendance, Attitude, Reading Mark, Writing Mark, Speaking Mark) of the students that are failed.

I don't know if the Excel fomulea could do that or have to use VBA to solve that problem. I don't know VBA so I prefer to use of formulea.

Could any one help me?

Thanks.

Case one of three mark equal 3??? Failed??
This is formula -- plz, see the attachment file :

Originally Posted by wowow

Thank sunflowers,

One out of three marks below 3 is considered as Failed. Mark from 3 upward is passed.

Plz, press Ctrl+F3 to see the formula in the name and see the attachment file again!
Thanks!

Hi,

Revised so it only copies values from the data list

Try now,

Changed it a bit